0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

select [Month], 
       sum(1) ActiveUsers
   
from
(

select Z.[Month], count(Z.ouid) cnt, Z.ouid as [User Link] 
from(
select CAST(
      cast(DATEPART(YYYY, Y.CreationDate) as varchar) + '-' + cast(DATEPART(MM, Y.CreationDate) as varchar) + '-01'
      as datetime) [Month], ouid
     
  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-field-theory%'
OR p2.tags LIKE '%general-relativity%'
OR p2.tags LIKE '%string-theory%'
OR p2.tags LIKE '%quantum-gravity%'
OR p2.tags LIKE '%statistical-mechanics%'
OR p2.tags LIKE '%condensed-matter%'
OR p2.tags LIKE '%renormalization%')  
group by p1.owneruserid, p1.creationdate
  ) Y group by ouid, CreationDate
  
) Z group by Z.ouid,Z.[Month]

) as X where X.cnt>2
group by [Month]
order by [Month] asc

view current version

edited sep 1 13

created sep 1 13 Manishearth