The Stats of a Tag only gives the Top-20 askers. This query can list more of them and give other info as well.
Q&A for active researchers, academics and students of physics
-- Top Askers for a Given Tag
-- The Stats of a Tag only gives the Top-20 askers. 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(Posts.Id) as Questions,
sum(Score) as Score,
CAST(AVG(CAST(Score AS float)) as numeric(6,1)) as [Avg]
JOIN PostTags ON PostTags.TagId = Tags.Id
JOIN Posts ON Posts.Id = PostTags.PostId
JOIN Users ON Users.Id = Posts.OwnerUserId
Tags.TagName = '##TagName##'