Number (count) of active users by reputation

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select reputation, count(id)
from users
where lastAccessDate >  DATEADD(month, ##maxMonthsInactive:int?3## * -1, CURRENT_TIMESTAMP)
and reputation >= ##minReputation:int?2##
group by reputation
order by reputation

Enter Parameters

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