New Users by Date (last 60 days)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Unix and Linux

Q&A for users of Linux, FreeBSD and other Un*x-like operating systems

select 
  cast(creationdate as date) as [Date],
  count(id) as [New Users]
from users
where creationdate >= dateadd(d,-60,getdate())
group by cast(creationdate as date)
order by cast(creationdate as date) desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results