SO new users monthly


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

;with x as
  select cast(cast(datepart(year, CreationDate) as varchar) + '-' + cast(datepart(month, CreationDate) as varchar) + '-01' as datetime) as period,
  from users
select period, count(1)
from x
group by period
order by period

Enter Parameters

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