select Users.Reputation, Users.DisplayName, Users.Location,

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics Meta

Q&A about the site for active researchers, academics and students of physics

select Users.Reputation, Users.DisplayName, Users.Location,
Badges.Name, Badges.Date 
From Users
inner join Badges On Users.Id = Badges.userid
where Location = 'South Africa' and Name = 'Enlightened' and DATEPART(year, Date) = 2016
Order By Users.Reputation DESC

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results