Q&A for users and developers of the Cardano cryptocurrency ecosystem
SELECT TOP 100 Users.Id AS [User Link], Users.Reputation, COUNT(Badges.UserId) AS [Badge Count], CAST(Users.Reputation AS DECIMAL) / COUNT(Badges.UserId) AS [Rep per Badge] FROM Users INNER JOIN Badges ON Users.Id = Badges.UserId GROUP BY Users.Id, Users.Reputation ORDER BY [Rep per Badge] DESC