Number of questions asked for a specific tag over time (cumulative)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

select datepart(yy,creationdate) *100 
     + datepart(mm,creationdate) as yyyymm
     , sum(count(p.id)) 
        over (
           --partition by datepart(yy,creationdate) *100 
           --           + datepart(mm,creationdate) 
           order by  datepart(yy,creationdate) *100 
                   + datepart(mm,creationdate)
           ROWS UNBOUNDED PRECEDING )
from posts p
inner join posttags pt on pt.postid = p.id
inner join tags t on t.id = pt.tagid
where t.tagname='java'
group by datepart(yy,creationdate) *100 
   + datepart(mm,creationdate) 
     order by 1

Enter Parameters

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