0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for scholars and enthusiasts of literature

select TOP 1 u.DisplayName, u.Reputation, count(b.Id) as BadgeCount from Users u
join Badges b ON u.AccountId = b.UserId
 where Location like '%South Africa'
 and year(b.Date) = 2016
 and b.name = 'Enlightened'
 group by u.DisplayName, u.Reputation
 order by u.Reputation

view current version

edited oct 27 20

created oct 27 20 anonymous