Q&A for Tridion developers and administrators
-- Most popular StackOverflow tags in May 2010
rate.TagName as Tag,
--row_number() over (order by rate.Rate desc) as MayRank,
--row_number() over (order by num.Num desc) as TotalRank,
rate.Rate as Questions
--num.Num as QuestionsTotal
(select count(PostId) as Rate,cast(Posts.CreationDate as date) as CreationDate, TagName
Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId
and Posts.CreationDate < '2022-06-01'
and Posts.CreationDate > '2022-05-01'
group by TagName,cast(Posts.CreationDate as date)) as rate
order by rate.rate desc