Number of Votes per Month

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

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

-- 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
  WHERE votes.userid = ##userid##
GROUP BY YEAR(CreationDate), MONTH(CreationDate)
ORDER BY 1 DESC, 2 DESC

Enter Parameters

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