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 enthusiasts and scholars of mythology and folklore
-- 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], sum(Answers.Score) as Score 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