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.