0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gardeners and landscapers

SELECT *, count(*) AS count FROM (
  SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, CreationDate), 0) AS [date], 
    t.TagName as [tag]
  FROM Posts p 
    JOIN PostTags pt ON pt.PostId = p.Id
    JOIN Tags t ON t.Id = pt.TagId
  WHERE t.tagName IN ('java')
) as X
GROUP BY [tag], date
ORDER BY [tag], date

fork query

created jan 10 18 anonymous