Time & dates
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.