Most decorated users
Q&A for professional and enthusiast programmers
SELECT TOP 300 row_number() over(order by count(*) desc) as rank, Badges.UserId AS [User Link], count(*) AS 'Badge Count', Users.Reputation AS 'Total user reputation', Users.Reputation / count(*) AS 'Ratio' 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 'Badge Count' DESC