instruction: Up/down vote breakdown for a post.
response: SELECT Posts.Id AS "post_link", Posts.Score AS "Score", COUNT(CASE WHEN Votes.VoteTypeId = 2 THEN 1 END) AS "UpVotes", COUNT(CASE WHEN Votes.VoteTypeId = 3 THEN 1 END) AS "DownVotes" FROM Posts JOIN Votes ON Votes.PostId = Posts.Id WHERE Posts.Id = '##post:int##' AND (Votes.VoteTypeId = 2 OR Votes.VoteTypeId = 3) GROUP BY Posts.Id, Posts.Score