Select u.DisplayName, u.Reputation, count(b.Name) as no_o...

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 u.DisplayName, u.Reputation, count(b.Name) as no_of_badges
from Users u
Inner Join Badges b on u.Id = b.UserId
Where u.Reputation in (
                    Select max(Reputation)
                    From Users
                    Where Location = 'South Africa'
                    )
And b.Name = 'Enlightened'
And year(b.Date) = '2016'
Group By u.DisplayName, u.Reputation

Enter Parameters

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