DECLARE @StartDate DATE = '2009-01-01'; DECLARE @EndDate ...

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

DECLARE @StartDate DATE = '2009-01-01';
DECLARE @EndDate DATE = '2023-12-31';

WITH TaggedQuestions AS (
  SELECT
    Id,
    CreationDate,
    CASE WHEN CHARINDEX('<reactjs>', Tags) > 0 THEN 1 ELSE 0 END AS ReactTag,
    CASE WHEN CHARINDEX('<angular>', Tags) > 0 THEN 1 ELSE 0 END AS AngularTag,
    CASE WHEN CHARINDEX('<vue.js>', Tags) > 0 THEN 1 ELSE 0 END AS VueTag
  FROM PostsWithDeleted
  WHERE
    PostTypeId = 1 AND 
    CreationDate >= @StartDate AND
    CreationDate <= @EndDate
),
MonthlyCounts AS (
  SELECT
    DATEADD(month, DATEDIFF(month, 0, CreationDate), 0) AS Month,
    SUM(ReactTag) AS React,
    SUM(AngularTag) AS Angular,
    SUM(VueTag) AS Vue
  FROM TaggedQuestions
  GROUP BY DATEADD(month, DATEDIFF(month, 0, CreationDate), 0)
)
SELECT
  Month,
  React,
  Angular,
  Vue
FROM MonthlyCounts
ORDER BY Month;

Enter Parameters

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