Badges to Aspire To

10

Please login or register to vote for this query.

(click on this box to dismiss)

Forget Gold / Silver / Bronze — how often are these badges really being handed out? Score is relative to the most common badge. Does not include tag badges.

Server Fault

Q&A for system administrators and IT professionals

-- Badges to Aspire To
-- Forget Gold / Silver / Bronze — how often are these badges really being handed out? Score is relative to the most common badge. Does not include tag badges.

SELECT DISTINCT name AS [Badge], count(name) AS [Count], (SELECT TOP 1 count(Name) FROM Badges WHERE NOT EXISTS (SELECT * FROM tags WHERE tags.tagname=badges.name) GROUP BY name ORDER BY count(Name) DESC) / count(Name) as [Value]
FROM badges
WHERE NOT EXISTS (SELECT * FROM tags WHERE tags.tagname=badges.name)
GROUP BY name
ORDER BY Count

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results