#how many posts were written each month

0

Please login or register to vote for this query.

(click on this box to dismiss)

Quantum Computing

Q&A for engineers, scientists, programmers, and computing professionals interested in quantum computing

SELECT a.[year-month], COUNT(a.Id) as post_count
FROM (
        SELECT  Id, PostTypeId, CONVERT(CHAR(4), CreationDate, 100) + 
        CONVERT(CHAR(4), CreationDate, 120) AS [year-month]
        FROM Posts
        ) as a        
GROUP BY [year-month]
ORDER BY [year-month];

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results