0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to bypass life's everyday problems with simple tricks

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

fork query

edited sep 20 Andy.Hattemer

created dec 7 17 Ted Petrou