0

Please login or register to vote for this query.

(click on this box to dismiss)

This query fetches the amount of questions asked per month, organized by year and month.

Q&A for anime and manga fans

-- Total of questions asked per month
-- This query fetches the amount of questions asked per month, organized by year and month.

SELECT
    datepart(year,CreationDate) as year,
    datepart(month,CreationDate) as month,
    COUNT(id) as total
FROM
    Posts
WHERE
    PostTypeId = 1
GROUP BY
    datepart(month,CreationDate),
    datepart(year,CreationDate)
ORDER BY
    datepart(year,CreationDate),
    datepart(month,CreationDate)

fork query

created oct 21 11 Paulo Cereda