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.