Q&A for pro webmasters
Select Top 50000 U.Id, sum(C.Score) as totalUpV, count(C.UserId) AS commperU From Users U Join Comments C ON(U.Id = C.UserId) Group By U.Id, C.Score Order By U.Id