0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

SELECT
  DATEADD(MONTH, DATEDIFF(MONTH, 0, CreationDate), 0),
  /*COUNT(CASE VoteTypeId WHEN 2 THEN 1 ELSE NULL END) AS UpVotes,*/
  /*COUNT(CASE VoteTypeId WHEN 3 THEN 1 ELSE NULL END) AS DownVotes,*/
  (
    CAST(COUNT(CASE VoteTypeId WHEN 2 THEN 1 ELSE NULL END) AS FLOAT) /
    CAST(COUNT(CASE VoteTypeId WHEN 3 THEN 1 ELSE NULL END) AS FLOAT)
  ) AS UpDownRatio
FROM Votes
WHERE CreationDate > '2009-01-01'
GROUP BY DATEADD(MONTH, DATEDIFF(MONTH, 0, CreationDate), 0)
ORDER BY DATEADD(MONTH, DATEDIFF(MONTH, 0, CreationDate), 0);

fork query

edited nov 16 Brad.Isbell

created nov 16 anonymous