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 badges FROM Badges INNER JOIN Users ON Badges.Name = 'Necromancer' AND Badges.Date < '##Date?9999-01-01##' GROUP BY UserId ORDER BY Badges DESC