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