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.

Q&A for science fiction and fantasy enthusiasts

-- 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

fork query

created may 4 11 mattdm