Exercise · SQL & Querying
Predict, then run it
Predict the output
sessions(id, ended) = 1→Jun-30 14:00, 2→Jul-01 00:00, 3→Jun-10 09:00. Sessions that ended in June:
SELECT id FROM sessions WHERE ended >= TIMESTAMP '2024-06-01' AND ended < TIMESTAMP '2024-07-01' ORDER BY id;
Predict the exact output.