Q&A for professional and enthusiast programmers
SELECT Users.Id AS [User Link], COUNT(1) AS [Badge Count] FROM Users INNER JOIN Badges ON Users.Id = Badges.UserId GROUP BY Users.Id ORDER BY [Badge Count] DESC