T-SQL Create Query - Compare and Calculate
Did CTE with RANK/OVER:

Rank3PM = RANK() OVER (ORDER BY [3PM per Game])


and in the select I ended with:

TotalPoints =  Rank3PM + RankREB + RankAST..


Thanks.