Q&A for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure
SELECT Max(u.reputation) as m, -- change to MAX if you want the highest
FROM Users u
JOIN Badges b ON b.UserId = u.Id
where b.Name = 'Enlightened'
and u.reputation = (select Max(reputation) from users where location like '%South Africa%')
YEAR(b.Date) = 2016
GROUP BY u.DisplayName