Reading performance & plans
Exercise · SQL & Querying

Predict, then run it

Predict the output

logins(id, at) = 1→Mar-05 08:00, 2→Mar-05 22:00, 3→Mar-06 01:00. The sargable way to get March-5 logins:

SELECT id FROM logins WHERE at >= TIMESTAMP '2024-03-05' AND at < TIMESTAMP '2024-03-06' ORDER BY id;

Predict the exact output.