SELECT u.DisplayName, COUNT(b.Id) FROM Users u, Badges b ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

SELECT u.DisplayName, COUNT(b.Id)
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')
AND LOWER(b.Name) = LOWER('Enlightened')
GROUP BY u.DisplayName;

Enter Parameters

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