Q&A for academics and those enrolled in higher education
SELECT TOP 20 Tags.tagname AS 'Tag', COUNT(Posts.id) AS 'Questions' FROM Tags JOIN PostTags ON PostTags.tagid = Tags.id JOIN Posts ON Posts.id = PostTags.postid WHERE Posts.ClosedDate IS NOT NULL GROUP BY Tags.tagname ORDER BY COUNT(Posts.id) DESC