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

0

Please login or register to vote for this query.

(click on this box to dismiss)

Sound Design

Q&A for sound engineers, producers, editors, and enthusiasts

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')
      AND Year(Posts.CreationDate) = 2014
      AND Month(Posts.CreationDate) = 01
      AND Day(Posts.CreationDate) = 22
      Group by Tags.TagName, CONVERT(date, Posts.CreationDate)

Enter Parameters

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