Q&A for users and developers of hardware and software for Raspberry Pi
Select TagName, row_number() over (order by Rate.Posts desc) as Rank, row_number() over (order by num.Total desc) as 'Total Rank', Rate.Posts as 'Questions over Timeframe', num.Total as 'Total Questions' From (Select TagName, count(p.Id) as Posts From Tags INNER JOIN PostTags ON PostTags.TagId = Tags.id INNER JOIN PostsWithDeleted as p ON (p.Id = PostTags.PostId) Where p.CreationDate >= ##Startdate:string?2019-01-01## and p.CreationDate <= ##Enddate:string?2019-02-01## Group By TagName) as Rate Left Join (select TagName as Tag, Count(Posts.Id) as Total From Tags Inner JOIN PostTags ON PostTags.TagId = Tags.Id Inner Join Posts ON (Posts.Id = PostTags.PostId) Group By TagName) as num ON num.Tag = Rate.TagName Order by Rank