Exercise · SQL & Querying
Predict, then run it
Predict the output
t(x) = 1,2,3. A season-reset job wrapped in a transaction that rolls back — DELETE is transactional on every engine:
BEGIN; DELETE FROM t; ROLLBACK; SELECT COUNT(*) AS n FROM t;
Predict the exact output.