GROUP BY squeezes each group into one row. Window functions compute across many rows but keep every row: exactly what a leaderboard, a running total or a "compared with last game" column needs.