Q&A for professional and enthusiast programmers
SELECT TOP 20 OwnerUserId AS [User Link], TopBadge, SUM(Score) AS TotalScore, COUNT(*) AS NofAnswers FROM Posts P INNER JOIN PostTags PT ON PT.PostId = P.ParentId INNER JOIN Tags T ON T.Id = PT.TagId INNER JOIN ( SELECT B.UserId, MIN(B.Class) AS TopBadge FROM Badges B WHERE B.Name = '##TagName##' AND B.TagBased > 0 GROUP BY B.UserId ) BB ON BB.UserId = P.OwnerUserId WHERE T.TagName = '##TagName##' AND P.OwnerUserId IS NOT null AND P.CommunityOwnedDate IS null AND P.PostTypeId = 2 GROUP BY P.OwnerUserId, TopBadge ORDER BY TopBadge, TotalScore DESC