WITH season_3pt_totals AS (
SELECT
season,
player_id,
player,g,
(x3p_per_game * 3 * g) AS total_3pt_points,
ROW_NUMBER() OVER (
PARTITION BY season
ORDER BY (x3p_per_game * 3 * g) DESC
) AS rn
FROM @kaggle.sumitrodatta_nba_aba_baa_stats.player_per_game
)
SELECT
season,
player,
total_3pt_points
FROM season_3pt_totals
WHERE rn = 1 and season>2000
ORDER BY season;