0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited jun 24 16

created jun 23 16 Nathan Tuggy