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 about the site 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] FROM Tags 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 WHERE Tags.TagName = '##TagName##' GROUP BY Users.Id, DisplayName ORDER BY sum(Answers.Score) DESC