Q&A for engineers, producers, editors, and enthusiasts spanning the fields of audio, video, and media creation
-- Top 100 Most Reputable Users (Top Answerers) for a Given Tag
-- The Stats of a Tag only gives the Top-100 answerers.
-- This query can list more of them and give other info as well.
SELECT TOP 100
Users.Id as [User Link],
max(Reputation) as Reputation,
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##'