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(v.CreationDate) year, MONTH(v.CreationDate) month, COUNT(*) number_of_votes, ( SELECT COUNT(*) FROM users u WHERE u.CreationDate <= CAST(CAST(YEAR(v.CreationDate) AS CHAR(4)) + '-' + CAST(MONTH(v.CreationDate) AS CHAR(2)) + '-01' AS date) ) number_of_users FROM votes v GROUP BY YEAR(v.CreationDate), MONTH(v.CreationDate) ORDER BY 1 DESC, 2 DESC