number of active users er month

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

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

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