Most decorated users
Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors
SELECT TOP 300
row_number() over(order by count(*) desc) as rank,
Badges.UserId AS [User Link],
count(*) AS 'Necromancer badges',
Users.Reputation / (10 * count(*)) AS 'Reputation / (10 * Badges)'
Users.id = Badges.UserId AND
Badges.Name = 'Necromancer' AND
Badges.Date < '##Date?9999-01-01##'
'Necromancer badges' DESC