Get all questions and answerers from tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Academia Meta

Q&A about the site for academics and those enrolled in higher education

SELECT
  year_month, 
  count(*) as posts_count
from (
  select 
    format(p.creationdate, 'yy-MM') as year_month
  from 
    posts as p join posttags as pt 
    on 
      p.id = pt.postid
    join tags as t 
    on 
      pt.tagid = t.id
  where 
    t.tagname = 'debezium' and 
    p.creationdate > '2015'
  ) temp
group by year_month
order by year_month

Enter Parameters

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