number of active users er month


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for active researchers, academics and students of physics

select count(n_posts) from
(select Count(Id) as n_posts ,1.000*datepart(year,CreationDate)+1.000*datepart(month,CreationDate)/12 as Month, OwnerUserId 
from Posts
where PostTypeId = 2
Group By OwnerUserId, 
1.000*datepart(year,CreationDate)+1.000*datepart(month,CreationDate)/12) a

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results