Last 30 days active users by rep score group

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
    cast(usr.Reputation/500 as int)*500 RepScore,
    -- todo: ^^ improve this clustering.
    count(*) Users
from 
    Users usr
where
    datediff(day, usr.LastAccessDate, getdate()) <= 30
group by
  cast(usr.Reputation/500 as int)*500
order by
  RepScore

Enter Parameters

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