NoSQL datastore questions by year

0

Please login or register to vote for this query.

(click on this box to dismiss)

スタック・オーバーフローMeta

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

select tags.tagname, year(cast(Posts.CreationDate As Date)), count(Posts.id) 
from
  Tags, PostTags, Posts
  where Tags.TagName IN ('cassandra','scylla','mongodb')
and Tags.Id = PostTags.TagId
and PostTags.PostId = Posts.id
and Posts.CreationDate > '2013-01-01'
and Posts.CreationDate < '2020-01-01'
GROUP BY tags.tagname, year(cast(Posts.CreationDate As Date))
ORDER BY tags.tagname

Enter Parameters

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