upvote/downvote ratio: 2015 through 2020

0

Please login or register to vote for this query.

(click on this box to dismiss)

Look at the Graph, to see the evolution of the upvote/downvote ratio.

Cognitive Sciences Meta

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

SELECT
datefromparts(YEAR(CreationDate), MONTH(CreationDate), 1) AS YearMonth
, (CAST(SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END) AS float) / nullif(CAST(SUM(CASE WHEN VoteTypeId = 3 THEN 1 ELSE 0 END) AS float),0)) AS Ratio
FROM Votes
WHERE CreationDate > '01-01-2015' AND CreationDate < '12-31-2020'
GROUP BY datefromparts(YEAR(CreationDate), MONTH(CreationDate), 1)
ORDER BY datefromparts(YEAR(CreationDate), MONTH(CreationDate), 1)

Enter Parameters

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