0

Please login or register to vote for this query.

(click on this box to dismiss)

The total number of votes (upvotes and downvotes) per month

Q&A for scientific skepticism

-- Number of Votes per Month
-- The total number of votes (upvotes and downvotes) per month

SELECT   YEAR(CreationDate) year, MONTH(CreationDate) month, COUNT(*) number_of_votes
FROM     votes
GROUP BY YEAR(CreationDate), MONTH(CreationDate)
ORDER BY 1, 2, 3

fork query

created sep 30 10 Daniel Vassallo