Q&A for scientists using computers to solve scientific problems
SELECT u.DisplayName, COUNT(b.Id) AS EnlightenedBadgeCount, u.Reputation FROM Users u JOIN Badges b ON u.Id = b.UserId WHERE u.Location LIKE '%South Africa%' AND b.Name = 'Enlightened' AND YEAR(b.Date) = 2016 GROUP BY u.DisplayName, u.Reputation ORDER BY u.Reputation DESC;