select DisplayName as 'Most reputable South African user'...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Anime and Manga

Q&A for anime and manga fans

select DisplayName as 'Most reputable South African user', count(*) as 'No. of Enlightened badges in 2016'
from users
left join badges 
on Users.Id = Badges.UserId
where UserId = (select max(Reputation) from Users where Location = 'South Africa') 
and Name = 'Enlightened' and Year(Date) = 2016 group by Displayname;

select max(Reputation) from Users where Location = 'South Africa';

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results