0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professionals and students of engineering

SELECT
  DateAdd(Month, DateDiff(Month, 0, CreationDate), 0) AS [Month],
  Count(*) AS [Total],
  Count(CASE VoteTypeID WHEN 2 THEN 1 END) AS [Up],
  Count(CASE VoteTypeID WHEN 3 THEN 1 END) AS [Down],
  100.0 * Count(CASE VoteTypeID WHEN 3 THEN 1 END) / Count(*) AS [Down%]
FROM Votes
WHERE (VoteTypeId = 2 OR VoteTypeId = 3)
GROUP BY DateDiff(Month, 0, CreationDate)
ORDER BY [Month]

fork query

edited sep 10 12

created sep 10 12 Gilles