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 = 'Enlightened' and Year(Date) = 2016 group by DisplayName;

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

fork query

edited apr 23

created apr 23 anonymous