The average number of votes (upvotes and downvotes) per answer per month
Q&A for scientific skepticism
-- Number of Votes per Answer per Month -- The average number of votes (upvotes and downvotes) per answer per month SELECT YEAR(v.CreationDate) year, MONTH(v.CreationDate) month, CAST(COUNT(*) AS float) / ( SELECT CAST (COUNT(*) AS float) FROM posts p WHERE YEAR(p.CreationDate) = YEAR(v.CreationDate) AND MONTH(p.CreationDate) = MONTH(v.CreationDate) AND p.PostTypeId = 2 ) votes_per_question FROM votes v GROUP BY YEAR(v.CreationDate), MONTH(v.CreationDate) ORDER BY 1 DESC, 2 DESC