0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

select u.Id, u.Reputation, u.DisplayName, u.Location from Users u
JOIN Badges b 
ON u.Id = b.UserId
where u.Location like 'South Africa%' 
And b.Name = 'Enlightened'
And b.Date >= '2016-01-01' and b.Date <= '2016-12-31'
order by u.Reputation desc

fork query

edited oct 26 20

created oct 25 20 anonymous