0

Please login or register to vote for this query.

(click on this box to dismiss)

Shows the top 50 askers by question count.

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

-- 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

view current version

edited apr 20 11

created apr 20 11 Renesis