0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for professional and independent game developers

select u.DisplayName,u.Location, Max(u.Reputation)
from posts p
join users u on u.id = p.owneruserid
join posttypes pt on pt.id = p.posttypeid
where u.Location = 'South Africa'
group by u.DisplayName, u.Location
order by Max(u.Reputation) desc

fork query

edited feb 21

created feb 21 anonymous