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