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 physical fitness professionals, athletes, trainers, and those providing health-related needs
-- 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],
Count(Posts.Id) as Answers,
sum(Score) as Score,
CAST(AVG(CAST(Score AS float)) as numeric(6,2)) as [Average Answer Score],
COUNT(*) AS UpVotes
INNER JOIN Users ON Users.Id = OwnerUserId
INNER JOIN PostTags ON PostTags.PostId = Posts.Id
INNER JOIN Tags ON Tags.Id = PostTags.TagId
TagName = 'debugging'