Q&A for linguists, etymologists, and serious English language enthusiasts
Select TagName, Count As TagQuestions, Sum(Late)*100/Count(*) As PctLate From (Select TagName, Count, IIf(DateDiff(d, Posts.CreationDate, Votes.CreationDate) < 7, 0, 1) As Late From Posts Inner Join Votes On Posts.Id = Votes.PostId Inner Join PostTags On Posts.ParentId = PostTags.PostId Inner Join (Select Top 50 Id, TagName, Count From Tags Order By Count Desc) TopTags On TagId = TopTags.Id Where VoteTypeId = 2) As Raw Group By TagName, Count Order By PctLate Desc