with t as (SELECT datepart("month",P.CreationDate) as mon...

0

Please login or register to vote for this query.

(click on this box to dismiss)

CiviCRM

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

with t as (SELECT
datepart("month",P.CreationDate) as month,
  datepart("year",P.CreationDate) as year
FROM
  Posts as P
WHERE
  P.PostTypeId = 1 AND P.tags LIKE '%<oracle>%'
  ),
 t2 as (SELECT
datepart("month",P.CreationDate) as month,
  datepart("year",P.CreationDate) as year
FROM
  Posts as P
WHERE
  P.PostTypeId = 1 AND P.tags LIKE '%<snowflake-cloud-data-platform>%'
  ),
 t3 as (SELECT
datepart("month",P.CreationDate) as month,
  datepart("year",P.CreationDate) as year
FROM
  Posts as P
WHERE
  P.PostTypeId = 1 AND P.tags LIKE '%<redshift>%'
  )
  select year, month, count(*) as cnt from t2 
GROUP BY 
  year, month 
ORDER BY
  year, month DESC;

Enter Parameters

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