SELECT CASE WHEN VoteTypeId = 2 THEN 'Upvote' WHEN VoteTy...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results