Contributing Users by Month

0

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

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