Q&A about the site for science fiction and fantasy enthusiasts
-- What is the name of the most reputable “South Africa” user
-- and how many “Enlightened” badges did they receive in 2016?
-- select id from PostTypes where name = 'Question';
select u.displayname, u.id from USERS u INNER JOIN BADGES b on u.id = b.UserId
u.reputation in (select max(reputation) from users where location='South Africa')