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 OwnerUserId as [User Link], COUNT(*) as PostCount, SUM(Score) as TotalScore FROM Posts WHERE PostTypeId=1 AND OwnerUserId != 1 GROUP BY OwnerUserId ORDER BY COUNT(*) DESC