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 people organizing, marketing or licensing open source development projects
-- 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