Exercise · SQL & Querying
Predict, then run it
Predict the output
soaks(guest, in_utc, out_utc) holds one session, UTC 06:30 → 07:00 on spring-forward night. The true duration comes from the UTC instants:
SELECT guest, CAST(date_diff('minute', in_utc, out_utc) AS INT) AS mins FROM soaks;Predict the exact output.