1WITH ranked_players AS (
2    SELECT
3        season,
4        player_id,
5        player,
6        pts_per_game,
7        g,
8        ROW_NUMBER() OVER (
9            PARTITION BY season
10            ORDER BY pts_per_game DESC
11        ) AS rn
12    FROM @kaggle.sumitrodatta_nba_aba_baa_stats.player_per_game
13)
14SELECT
15    season,
16    SUM(pts_per_game * g) AS combined_points_top_10
17FROM ranked_players
18WHERE rn <= 10 and season>2000 and season<2025
19GROUP BY season
20ORDER BY season;
21