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

0

Please login or register to vote for this query.

(click on this box to dismiss)

Statistical Analysis

Q&A for people interested in statistics, machine learning, data analysis, data mining, and data visualization

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

Enter Parameters

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