Agora.IO.2021

0

Please login or register to vote for this query.

(click on this box to dismiss)

Anime and Manga

Q&A for anime and manga fans

SELECT ID, TagName
INTO #MyTags
FROM Tags
WHERE 
  --TagName = 'vim'
  --TagName = 'maxima'
  --TagName IN ('c++17', 'c++20')
  TagName IN ('agora.io')
  
SELECT MONTH(Posts.CreationDate) MONTH, COUNT(*) COUNT 
FROM Posts
  join PostTags ON PostTags.PostID = Posts.ID
  join Tags ON Tags.ID = PostTags.TagID
  WHERE TagID in (SELECT ID FROM #MyTags) AND YEAR(Posts.CreationDate) = '2021'
GROUP BY Month(Posts.CreationDate)

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results