Q&A about the site for people studying math at any level and professionals in related fields
select u.displayname, u.reputation, count(*) 'No of badges' from users u, badges b where u.id = b.userid and b.name = 'Enlightened' and u.location = 'South Africa' and year(b.date) = '2016' group by u.displayname, u.reputation order by u.reputation desc;