Window Functions

Calculating across related rows without collapsing them.

1. 14I want every employee AND their department average
2. 15Ranking
3. 16What happened before this row?
4. 17Running totals
5. 18Moving averages