Windows II — frames & running
Exercise · SQL & Querying

Predict, then run it

Predict the output

scores(player, at, pts) = (A,1,10),(A,1,20),(A,2,5) — two rows tie at at=1. Row-by-row running total:

SELECT at, SUM(pts) OVER (ORDER BY t, pts ROWS UNBOUNDED PRECEDING) AS running FROM scores ORDER BY at, pts;

Predict the exact output.