Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Exchange

Q&A about the Stack Exchange Network

Select Max(u.Reputation) As [Reputation], u.DisplayName As [Name], u.location As [Location], Count(b.Id) As [Badges],
b.Name As [Badge Names], Cast(Year(b.Date)As Varchar(4)) As [Year]
FROM Users u
Inner Join Badges b
On b.UserId = u.Id
Where u.location = 'South Africa'
And b.Name = 'Enlightened'
And Year(b.Date) = 2016
Group By u.DisplayName, u.location, b.Name, 
Cast(Year(b.Date)As Varchar(4))
Order by Cast(Year(b.Date)As Varchar(4)) desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results