SELECT YEAR(Posts.CreationDate) AS [Year] , MONTH(...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT      YEAR(Posts.CreationDate) AS [Year]
        ,   MONTH(Posts.CreationDate) AS [Month]
        ,   COUNT(Posts.Id) AS [Count]
FROM        Votes
        ,   Posts
WHERE       Votes.VoteTypeId = 6 /* Close Vote */
        AND Votes.CreationDate BETWEEN '2013-05-01' AND '2013-05-31'
        AND Posts.Id = Votes.PostId
GROUP BY    YEAR(Posts.CreationDate)
        ,   MONTH(Posts.CreationDate)
ORDER BY    YEAR(Posts.CreationDate) DESC
        ,   MONTH(Posts.CreationDate) DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results