PRECEDING

Running totals

Correlated subqueries