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

0

Please login or register to vote for this query.

(click on this box to dismiss)

スタック・オーバーフロー

プログラマーとプログラミングに熱心な人々のための質問と回答

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 Reputation = (select max(Reputation) from Users where Location = 'South Africa') 
and Name = 'Enlightetned' 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