Tag-badge leaderboard for a specific tag

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 100
  SUM(answers.Score) AS 'Total Score',
  COUNT(answers.Id) AS 'Total answers',
  answers.OwnerUserId AS [User Link]
FROM Posts answers
INNER JOIN Posts questions ON questions.Id = answers.ParentId
WHERE answers.CommunityOwnedDate IS NULL
  AND questions.Tags LIKE '%'+##tag##+'%'
  AND answers.PostTypeId=2 --answers
  AND answers.OwnerUserId IS NOT NULL
GROUP BY answers.OwnerUserId
ORDeR BY SUM(answers.Score) DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results