0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

SELECT 
    DATEPART(YEAR, CreationDate) AS Year, 
    DATEPART(MONTH, CreationDate) AS Month, 
    COUNT(*) AS QuestionsCount
FROM 
    Posts
WHERE 
    PostTypeId = 1 -- 1 indicates questions
    AND CreationDate >= DATEADD(YEAR, -20, GETDATE())
GROUP BY 
    DATEPART(YEAR, CreationDate), 
    DATEPART(MONTH, CreationDate)
ORDER BY 
    Year, 
    Month;

fork query

created nov 18 PAGAN