Quiz
RANGE vs ROWS Default Frame Peers
How the implicit RANGE frame handles tied ORDER BY values in a running total.
Given table t(d, amt) with rows (1,10), (1,20), (2,5), what does SUM(amt) OVER (ORDER BY d) return for each row (in row order 10, 20, 5)?