Q&A about the site for science fiction and fantasy enthusiasts
Select u.DisplayName, u.Reputation, count(b.Name) as no_of_badges
from Users u
Inner Join Badges b on u.Id = b.UserId
Where u.Reputation in (
Where Location = 'South Africa'
And b.Name = 'Enlightened'
And year(b.Date) = '2016'
Group By u.DisplayName, u.Reputation