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