Q&A for community managers, administrators, and moderators
SELECT TOP 100 Users.Id as [User Link], COUNT(1) as [Answer Count], Users.Reputation, SUM(p.Score) as [2012 Answer Upvotes] FROM Users INNER JOIN Posts p ON Users.Id = p.OwnerUserId AND p.PostTypeId = 2 GROUP BY Users.Id, Users.Reputation ORDER BY [Answer Count] DESC