0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited jan 16 14

created jan 16 14 retailcoder