Q&A for pro webmasters
-- Users ranked by number of badges (all kinds) SELECT TOP 100 * FROM ( SELECT Users.Id as [User Link], COUNT(*) as [NumBadges] FROM Users INNER JOIN Badges ON Users.Id = Badges.UserId GROUP BY Users.Id ) as UsersWithBadgeCount ORDER BY NumBadges DESC