number of users

0

Please login or register to vote for this query.

(click on this box to dismiss)

DevOps

Q&A for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

SELECT Max(u.reputation) as m,  -- change to MAX if you want the highest
         u.DisplayName, 
         count(*)
    FROM Users u
    JOIN Badges b ON b.UserId = u.Id
    where b.Name = 'Enlightened'
    and u.reputation = (select Max(reputation) from users where location like '%South Africa%')
    and
    YEAR(b.Date) = 2016
GROUP BY u.DisplayName

Enter Parameters

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