Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation
-- Gold tag badges by number of times awarded
SELECT TOP 200 Name AS "Badge name", Count(UserId) as "Number of times awarded"
FROM Badges b
WHERE b.TagBased=1 and b.class=1
GROUP BY Name
ORDER BY "Number of times awarded" DESC