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