0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users of Linux, FreeBSD and other Un*x-like operating systems

SELECT 
    YEAR(CreationDate) AS Year,
    CAST(SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END) AS FLOAT) / 
    CAST(SUM(CASE WHEN VoteTypeId = 3 THEN 1 ELSE 0 END) AS FLOAT) AS UpvoteDownvoteRatio
FROM 
    Votes
WHERE 
    YEAR(CreationDate) BETWEEN 2009 AND 2023
GROUP BY
    YEAR(CreationDate)
ORDER BY
    YEAR(CreationDate);

fork query

created mar 12 jon.doe34463