1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for power users of Apple hardware and software

-- Gold tag badges by number of times awarded
-- https://i.stack.imgur.com/rEr6F.png
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

fork query

edited may 21 20

created may 21 20 wim