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;