SO new users monthly

0

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

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