Will count the amount of badges a user has (Gold, Silver, Bronze) and rank them by it.
Q&A for Ubuntu users and developers
SELECT DisplayName AS Name,COUNT(badges.id) AS Badges, CONCAT('https://askubuntu.com/users/',badges.UserId) AS Link FROM users,badges WHERE users.id = badges.UserId GROUP BY DisplayName, badges.UserId HAVING count(badges.id) > 100 ORDER BY Badges DESC