Q&A for enthusiasts and power users of the Android operating system
-- Montly new user signup rates with graph
cast(DATEPART(YYYY, CreationDate) as varchar) + '-' + cast(DATEPART(MM, CreationDate) as varchar) + '-01'
as datetime) [Month]
from Users p
) as X
group by [Month]
order by [Month] asc