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