Q&A for pro webmasters
Select Top 50000 U.Id, U.DisplayName, U.UpVotes, count(*) as totalPosts From Posts P JOIN Users U ON(P.OwnerUserId = U.Id) Group By U.Id, U.DisplayName, U.UpVotes Order By U.Id