Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
-- How many upvotes do I have for each tag? -- How long before tag badges? SELECT TOP 100 Users.Id, DisplayName, Count(Posts.Id) AS Answers, AVG(CAST(Score AS float)) AS AverageAnswerScore FROM Posts INNER JOIN Users ON Users.Id = OwnerUserId WHERE PostTypeId = 2 GROUP BY Users.Id, DisplayName HAVING Count(Posts.Id) > 100 ORDER BY AverageAnswerScore DESC