SELECT u.DisplayName, COUNT(b.Id) as 'Number of Enlighten...


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) as 'Number of Enlightened Badges'
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') AND YEAR(b.Date) = 2016
GROUP BY u.DisplayName;

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results