GROUP BY squeezes rows together, but a leaderboard needs every row and its position. Window functions calculate across a set of rows, the window, while keeping each row in the result.