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)