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, C.UserId Order By U.Id