The Stats of a Tag only gives the Top-20 answerers. This query can list more of them and give other info as well.
Q&A for Drupal developers and administrators
-- Top Answerers for a Given Tag
-- The Stats of a Tag only gives the Top-20 answerers. This query can list more of them and give other info as well.
SELECT TOP 100
Users.Id as [User Link],
max(Age) as Age,
max(Location) as Location,
max(WebsiteUrl) as Website,
max(Reputation) as Rep,
Count(Answers.Id) as Answers,
sum(Answers.Score) as Score,
CAST(AVG(CAST(Answers.Score AS float)) as numeric(6,1)) as [Avg]
JOIN PostTags ON PostTags.TagId = Tags.Id
JOIN Posts ON Posts.Id = PostTags.PostId
JOIN Posts as Answers ON Answers.ParentId = Posts.Id
JOIN Users ON Users.Id = Answers.OwnerUserId
Tags.TagName = '##TagName##'