Windows II — frames & running
Exercise · SQL & Querying

Predict, then run it

Predict the output

runs(day, secs) = (1,50),(2,45),(3,60). Each day beside the season's final ascent time — needs the explicit full frame:

SELECT day, LAST_VALUE(secs) OVER (ORDER BY day ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS final FROM runs ORDER BY day;

Predict the exact output.