Q&A about the site for Tridion developers and administrators
SELECT displayName, count(Name) number_of_Enlightened_Badges from Badges as badges inner join ( SELECT id,displayName FROM USERS WHERE LOCATION='South Africa' and reputation in(SELECT MAX(Reputation) FROM USERS WHERE LOCATION='South Africa') ) as southAfricaHighestReputation on badges.userID=southAfricaHighestReputation.id where YEAR(Badges.Date)='2016' AND NAME='Enlightened' group by displayName,Name