Q&A for Joomla! administrators, users, developers and designers
rate.TagName as Tag,
row_number() over (order by rate.Rate desc) as Q1Rank,
rate.Rate as QuestionsInQ12019
(select count(PostId) as Rate, TagName
Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId
and Posts.CreationDate < '2019-03-22'
and Posts.CreationDate > '2019-02-22'
group by TagName) as rate