Ratio of downvoted questions over time.

1

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.

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
datefromparts(YEAR(CreationDate), MONTH(CreationDate), 1) AS YearMonth
, 1/(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-2012'
GROUP BY datefromparts(YEAR(CreationDate), MONTH(CreationDate), 1)
ORDER BY datefromparts(YEAR(CreationDate), MONTH(CreationDate), 1)

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results