SQL Window Functions: How to Get the Top Row Per Group

A window function adds a number to every row without collapsing any of them. Here is OVER, PARTITION BY, ROW_NUMBER, RANK, DENSE_RANK, running totals and LAG, worked on a real 175-game list.