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
Posts as P
P.PostTypeId = 1 AND P.tags LIKE '%<oracle>%'
select count(*), year, month from t
year, month DESC;