0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT 
CASE
  WHEN VoteTypeId = 2 THEN 'Upvote'
  WHEN VoteTypeId = 3 THEN 'Downvote'
END,
COUNT(VoteTypeId)

FROM Votes
WHERE VoteTypeId IN (2,3)

GROUP BY VoteTypeId

fork query

edited jun 20

created jun 20 anonymous