Q&A for users and developers of the Cardano cryptocurrency ecosystem
select u.DisplayName,u.Location, Max(u.Reputation) from posts p join users u on u.id = p.owneruserid where u.Location = 'South Africa' group by u.DisplayName, u.Location order by Max(u.Reputation) desc