Select top 1 u.DisplayName, u.Reputation, count(b.Name) a...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy Meta

Q&A about the site for science fiction and fantasy enthusiasts

Select top 1 u.DisplayName, u.Reputation, count(b.Name) as no_of_badges
from Users u
Inner Join Badges b on u.Id = b.UserId
Where b.Name = 'Enlightened'
and u.Location = 'South Africa'
And year(b.Date) = '2016'
Group By u.DisplayName, u.Reputation
order by u.Reputation Desc

Enter Parameters

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