0

Please login or register to vote for this query.

(click on this box to dismiss)

The number of questions asked each year that did NOT have the [dnd-5e] tag.

Q&A about the site for students and teachers of all martial arts

SELECT YEAR(p.CreationDate) as Year, COUNT(iif(PostTypeId=1, p.Id, null)) as Questions

FROM Posts p

WHERE p.PostTypeId = 1
  AND p.Id NOT IN (SELECT PT.PostId
                   FROM PostTags PT
                   LEFT JOIN Posts P2 on P2.Id = PT.PostId
                   LEFT JOIN Tags T on T.Id = PT.TagId
                   WHERE P2.PostTypeId = 1 AND T.TagName = 'dnd-5e')

GROUP BY YEAR(p.CreationDate)

ORDER BY YEAR(p.CreationDate) ASC;

fork query

edited jan 14 22

created jan 14 22 Oblivious.Sage