0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software quality control experts, automation engineers, and software testers

select 
DISTINCT tagName, CAST(CreationDate AS date) AS post_date, COUNT(PostId) OVER (PARTITION BY tagName ORDER BY CAST(CreationDate AS date)) num_posts
FROM 
Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId
and Posts.CreationDate > '2008-01-01'
and Posts.CreationDate < '2020-11-09'
AND tagName IN 
('azure-communication-services', 'amazon-chime', 'aws-chime-sdk')
ORDER BY 1, 2 ASC

fork query

edited nov 30

created aug 17 anonymous