Diese Lektion gibt es vorerst nur auf Englisch.
Rank without losing rows
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.