Q&A for developers and researchers interested in open data
select Count(Badges.Name) AS TotalBadge, DisplayName, MAX(Reputation) AS MaxReputation from Users Inner Join Badges ON Users.AccountId = Badges.UserId where Location = 'South Africa' and name = 'Enlightened' and Badges.Date >= '2016-01-01 00:00:01' and Badges.date <= '2016-12-31 00:00:00' GROUP BY DisplayName;