instruction: Cassandra question count by day.
response: SELECT TIME_TO_STR(Posts.CreationDate, '%YEAR') AS Year, TIME_TO_STR(Posts.CreationDate, '%-mONT%-H') AS Month, COUNT(Posts.Id), COUNT(Posts.AnswerCount), COUNT(Posts.CommentCount) FROM Tags, PostTags, Posts WHERE Tags.TagName = 'cassandra' AND Tags.Id = PostTags.TagId AND PostTags.PostId = Posts.Id AND Posts.CreationDate < '2016-10-01' AND Posts.CreationDate > '2015-01-01' GROUP BY TIME_TO_STR(Posts.CreationDate, '%YEAR'), TIME_TO_STR(Posts.CreationDate, '%-mONT%-H') ORDER BY Year, Month