0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientific skepticism

SELECT
      DATEPART(yyyy, Posts.CreationDate) AS Year,
      DATEPART(mm, Posts.CreationDate) AS Month,
      Tags.TagName AS ProgrammingLanguage,
      COUNT(*) AS NumQuestions
    FROM
      Posts
    INNER JOIN
      PostTags ON Posts.Id = PostTags.PostId
    INNER JOIN
      Tags ON Tags.Id = PostTags.TagId
    WHERE
      Posts.PostTypeId = 1 -- 1 for Questions
      AND Tags.TagName IN ('c', 'c++', 'python', 'rust') -- your programming languages here
      AND DATEPART(yyyy, Posts.CreationDate) = 2015
    GROUP BY
      DATEPART(yyyy, Posts.CreationDate),
      DATEPART(mm, Posts.CreationDate),
      Tags.TagName
    ORDER BY
      Year, Month, NumQuestions DESC

fork query

created sep 25 23 Trag Date