Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs
SELECT u.DisplayName, COUNT(b.Id) as 'Number of Enlightened Badges'
FROM Users u, Badges b
WHERE u.Id = b.UserId
AND Location = 'South Africa'
AND Reputation = (SELECT MAX(Reputation )
WHERE Location = 'South Africa')
AND LOWER(b.Name) = LOWER('Enlightened') AND YEAR(b.Date) = 2016
GROUP BY u.DisplayName;