Shows the top 50 answerers by answer count.
Q&A for programmers
-- Most Prolific Answerers (with score)
-- Shows the top 50 answerers by answer count.
SELECT TOP 50
OwnerUserId as [User Link],
COUNT(*) as PostCount,
SUM(Score) as TotalScore
WHERE PostTypeId=2 AND OwnerUserId != 1
GROUP BY OwnerUserId
ORDER BY COUNT(*) DESC