Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language
SELECT COUNT(Badges.Name) as award_num, Users.Id, Users.DisplayName FROM Badges RIGHT JOIN Users ON Badges.UserId = Users.Id group by Users.Id, Users.DisplayName order by award_num desc