0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people interested in the history and origins of science and mathematics

SELECT
    DATEPART(YEAR, CreationDate) AS Year,
    DATEPART(MONTH, CreationDate) AS Month,
    t.TagName,
    COUNT(*) AS QuestionCount
FROM
    Posts p
    INNER JOIN PostTags pt ON p.Id = pt.PostId
    INNER JOIN Tags t ON pt.TagId = t.Id
WHERE
    p.PostTypeId = 1
    AND t.TagName IN ('python', 'labview')
GROUP BY
    DATEPART(YEAR, CreationDate),
    DATEPART(MONTH, CreationDate),
    t.TagName
ORDER BY
    Year,
    Month,
    t.TagName;

fork query

created nov 25 anonymous