Q&A about the site for people who use Blender to create 3D graphics, animations, or games
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