Data modification & MERGE
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.