SELECT u.Id, u.Reputation, u.DisplayName, u.Location FROM...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT u.Id, u.Reputation, u.DisplayName, u.Location
FROM Users u, Badges b
WHERE u.Id = b.UserId
AND Location = 'South Africa' 
AND Reputation = (SELECT MAX(Reputation )
                  FROM Users
                  WHERE Location = 'South Africa');

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results