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.