SQL Windows: Ranking, Partitions & Running Totals

Understand row-preserving analytics and make ordering and window frames explicit.