Q3

0

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, u.location, Count(b.Id) As [Badges],
b.Name As [Badge Names], Cast(Year(b.Date)As Varchar(4)) 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

Options:
Switch sites:
loading Hold tight while we fetch your results