0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

SELECT
  DATEADD(m, DATEDIFF(m, 0, Posts.CreationDate), 0) AS Month,
  Tags.TagName AS Tag ,
  Count(*) AS Questions
FROM
  Tags
  LEFT JOIN PostTags ON PostTags.TagId = Tags.Id
  LEFT JOIN Posts ON Posts.Id = PostTags.PostId
  LEFT JOIN PostTypes ON PostTypes.Id = Posts.PostTypeId
WHERE
  Tags.TagName ='dplyr'
  AND PostTypes.Name = 'Question'
  AND CreationDate >= DATEADD(m, DATEDIFF(m, 0, GETDATE())-50,0)
  AND CreationDate < DATEADD(m, DATEDIFF(m, 0, GETDATE()), 0)
GROUP BY
  DATEADD(m, DATEDIFF(m, 0, Posts.CreationDate), 0), Tags.TagName
ORDER BY
  DATEADD(m, DATEDIFF(m, 0, Posts.CreationDate), 0), Tags.TagName;

fork query

edited mar 23 18 anonymous

created apr 5 16 Abtin.Forouzandeh