Q&A for people studying math at any level and professionals in related fields
WITH a AS ( SELECT OwnerUserId, CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END Upvote, CASE WHEN VoteTypeId = 3 THEN 1 ELSE 0 END DownVote FROM Posts p INNER JOIN Votes v ON v.PostId = p.Id ) Select OwnerUserId, sum(Upvote), sum(DownVote) from a Group By OwnerUserId