COURSE 11 OF 15
Window Functions II: Running Values
Let each row see the rows before and after it: running totals, changes from the previous row, gaps to the next, and moving windows.
Builds on
Best read after 10. Window Functions I: Ranking and Top-N — you can still read ahead, but some of this may lean on ideas covered there.