Filtering & predicates
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.