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