Most decorated users
Q&A for those who study, teach, research and apply economics and econometrics
SELECT TOP 300 row_number() over(order by count(*) desc) as rank, Badges.UserId AS [User Link], count(*) AS 'Necromancer badges', Users.Reputation 'Reputation', Users.Reputation / (10 * count(*)) AS 'Reputation / (10 * Badges)' FROM Badges INNER JOIN Users ON Users.id = Badges.UserId AND Badges.Name = 'Necromancer' AND Badges.Date < '##Date?9999-01-01##' GROUP BY Badges.UserId, Users.Reputation ORDER BY 'Necromancer badges' DESC