0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

SELECT TOP 20
  Tags.TagName as [Tag],
  COUNT(*) as [Count]
FROM PostTags
JOIN Tags ON (PostTags.TagId = Tags.Id)
JOIN Posts Question ON (PostTags.PostId = Question.Id)

WHERE Question.PostTypeId = 1 -- Question
  AND Question.ClosedDate IS NULL -- Exclude Closed questions
  AND AnswerCount > 0 -- Has answers
  AND (Tags.TagName LIKE 'amazon-%' OR Tags.TagName LIKE 'aws-%')
  AND Question.CreationDate > DATEADD(MONTH,-12,GETDATE()) -- Past 3 months

GROUP BY Tags.TagName
ORDER BY COUNT(*) DESC

fork query

edited jan 24 anonymous

created dec 30 John Rotenstein