Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation
SELECT TOP(##num?500##) u.Id AS [User Link], u.Reputation, SUM(case when p.PostTypeId = 1 then 1 else 0 end) AS [Total Questions], SUM(case when p.PostTypeId = 2 then 1 else 0 end) AS [Total Answers], SUM(case when p.PostTypeId = 1 then p.Score else 0 end) AS [Score Questions], SUM(case when p.PostTypeId = 1 then p.Score else 0 end) AS [Score Answers] FROM Users u INNER JOIN Posts p ON p.OwnerUserId=u.Id GROUP BY u.Id, u.Reputation ORDER BY u.Reputation DESC