Top Answerers (with score)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Shows the top 50 askers by question count.

Stack Overflow

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,
  AVG(Score) as PerAnswerAverage
FROM Posts
WHERE PostTypeId=2 AND OwnerUserId != 1
GROUP BY OwnerUserId
ORDER BY COUNT(*) DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results