0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

SELECT 
    CONVERT(VARCHAR(7), CreationDate, 20) AS year_month,
    COUNT(*) AS post_count
FROM
    posts
GROUP BY
    CONVERT(VARCHAR(7), CreationDate, 20)
ORDER BY
    year_month

fork query

edited oct 3

created oct 3 anonymous