COURSE 10 OF 15
Window Functions I: Ranking and Top-N
Compute a value across a set of rows without collapsing them, then rank, pick the top few, or compare each row to its group.
Builds on
Best read after 2. Grouping and Aggregation, 5. Sorting and Pagination — you can still read ahead, but some of this may lean on ideas covered there.