0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Query to find the number of questions asked per month and year
SELECT
    YEAR(CreationDate) AS [Year],
--    MONTH(CreationDate) AS [Month],
    COUNT(*) AS [NumberOfQuestions]
FROM
    Posts
WHERE
    PostTypeId = 1 -- PostTypeId = 1 for Questions
GROUP BY
    YEAR(CreationDate)
--    MONTH(CreationDate)
ORDER BY
    [Year] DESC;
--    [Month] DESC

fork query

edited jan 24 24

created jan 24 24 Harshvardhan