0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Drupal developers and administrators

SELECT
    DATEFROMPARTS(YEAR(CreationDate), MONTH(CreationDate), 1) AS [Month],
    COUNT(*) AS [Questions]
FROM
    Posts
WHERE
    CreationDate >= '2009-01-01'
    AND PostTypeId = 1
GROUP BY
    YEAR(CreationDate),
    MONTH(CreationDate)
ORDER BY
    [Month] DESC;

fork query

edited nov 27

created nov 27 anonymous