Running Total

0001-01-01

Running Totals and Moving Averages

SUM OVER with ORDER BY gives you a running total. Add a ROWS BETWEEN frame and you get a sliding window — a moving average that looks back exactly N rows.