Exercise · SQL & Querying
Predict, then run it
Predict the output
swipes(id, at) = 1→Jan-31 09:00, 2→Feb-01 00:00, 3→Jan-15 12:00. January swipes, the bankable way:
SELECT id FROM swipes WHERE at >= TIMESTAMP '2024-01-01' AND at < TIMESTAMP '2024-02-01' ORDER BY id;
Predict the exact output.