Baselight
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;
seasonplayertotal_3pt_points
2001Antoine Walker656.1000000000001
2002Ray Allen683.0999999999999
2003Ray Allen592.8000000000001
2004Peja Stojaković729
2005Kyle Korver688.7999999999998
2006Ray Allen795.5999999999999
2007Gilbert Arenas621.5999999999999
2008Jason Richardson738
2009Rashard Lewis663.5999999999999
2010Aaron Brooks615
2011Dorell Wright590.4
2012Ryan Anderson494.1000000000001
2013Stephen Curry819
2014Stephen Curry772.1999999999999
2015Stephen Curry864
2016Stephen Curry1208.6999999999998
2017Stephen Curry971.6999999999999
2018James Harden799.2
2019James Harden1123.1999999999998
2020James Harden897.6
2021Stephen Curry1001.6999999999999
2022Stephen Curry864
2023Klay Thompson910.8000000000001
2024Stephen Curry1065.6
2025Anthony Edwards384

Share link

Anyone who has the link will be able to view this.