Who is grabbing the most rep that has a nontrivial amount of necro badges?
Q&A for power users of Apple hardware and software
SELECT TOP 500 row_number() over(order by count(*) desc) as rank, Badges.UserId AS [User Link], count(*) AS 'Necros', Users.Reputation 'Reputation', Users.Reputation / count(*) AS 'RepPerNecro' 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 HAVING count(*) > 10 AND Users.Reputation > 10000 ORDER BY 'RepPerNecro' ASC