Stackoverflow

4
(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
    DATEFROMPARTS(YEAR(CreationDate), MONTH(CreationDate), 1) AS [Month],
    COUNT(*) AS [Questions]
FROM Posts
WHERE 
    PostTypeId = 1
GROUP BY 
    DATEFROMPARTS(YEAR(CreationDate), MONTH(CreationDate), 1)
ORDER BY 
    [Month] ASC
Options:
Switch to meta site
Hold tight while we fetch your results
2010
2012
2014
2016
2018
2020
2022
2024
2026
0
50000
100000
150000
200000
250000
Questions
220 rows returned in <1 ms