Number of active users in a set of tags month wise

0

Please login or register to vote for this query.

(click on this box to dismiss)

A user is considered "active" if they have > "threshhold" posts in the given set of tags, where "threshhold" is a parameter that can be set by modifying the textbox below.

Ukrainian Language Meta

Q&A about the site for linguists, teachers and students of the Ukrainian language

select [Month], 
       sum(1) Questions
   
from
(
  select CAST(
      cast(DATEPART(YYYY, Y.CreationDate) as varchar) + '-' + cast(DATEPART(MM, Y.CreationDate) as varchar) + '-01'
      as datetime) [Month], count(Y.ouid)  cnt
     
  from (
   select p1.creationdate  CreationDate ,p1.owneruserid  ouid from posts p1
      inner join posts p2  on p1.parentid=p2.id 
      where p1.posttypeid=2 and (p2.tags like '%quantum-mechanics%') 
  ) Y group by Y.ouid,Y.CreationDate
) as X where cnt>2
group by [Month]
order by [Month] asc

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results