Contributing Users by Month

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

select max(Reputation) as reputation, ntile
from(

select Id, Reputation, ntile(100) over(order by Reputation) as ntile
from Users
where Id in(
  select OwnerUserId
  from Posts
  where CreationDate >= '2008-08-01' and CreationDate < '2019-06-01'
union
  select UserId
  from Comments
  where CreationDate >= '2008-08-01' and CreationDate < '2019-06-01'
)

) as alias
group by ntile

Enter Parameters

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