Most decorated users
Q&A for people looking to bypass life's everyday problems with simple tricks
SELECT TOP 300
row_number() over(order by count(*) desc) as rank,
Badges.UserId AS [User Link],
count(*) AS badges
Badges.Name = 'Necromancer' AND
Badges.Date < '##Date?9999-01-01##'