0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

select DATEDIFF(week,LastAccessDate,GETDATE()), COUNT(Id)
from Users
where Reputation >= ##MinRep##
group by DATEDIFF(week,LastAccessDate,GETDATE())
order by DATEDIFF(week,LastAccessDate,GETDATE()) asc

fork query

edited nov 29 13

created nov 28 13 anonymous