SELECT Tags.TagName, CONVERT(date, Posts.CreationDate), C...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

SELECT
Tags.TagName,
CONVERT(date, Posts.CreationDate),
COUNT(Posts.Id) AS num_questions

FROM  Posts
    INNER JOIN PostTags ON Posts.Id          = PostTags.PostId
    INNER JOIN Tags     ON PostTags.TagId    = Tags.id
WHERE
      (Tags.TagName = 'sql'
      or Tags.TagName = 'php'
      or Tags.TagName = 'python'
      or Tags.TagName = 'ruby'
      or Tags.TagName = 'objective-c'
      or Tags.TagName = 'jquery'
      or Tags.TagName = 'java'
      or Tags.TagName = 'javascript'
      or Tags.TagName = 'c'
      or Tags.TagName = 'c#'
      or Tags.TagName = 'C++')
      AND Year(Posts.CreationDate) = 2018
      AND Month(Posts.CreationDate) = 06
      AND Day(Posts.CreationDate) = 13
      Group by Tags.TagName, CONVERT(date, Posts.CreationDate)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results