Most Prolific Answerers (with score)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Shows the top 50 answerers by answer count.

Stack Overflow

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached