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)

Gardening and Landscaping

Q&A for gardeners and landscapers

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>%'
  )
  select count(*), year, month from t 
GROUP BY 
  year, month 
ORDER BY
  year, month DESC;

Enter Parameters

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