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 month and year. Modified to sort by year first.

Q&A about the site for teachers and students of the Esperanto language

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

SELECT
    datepart(month,CreationDate) as month,
    datepart(year,CreationDate) as year,
    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 Andrew Stacey