Q&A for professional and enthusiast programmers
SELECT count(*) as TotalVotes, SUM(CASE WHEN PostTypeId = 1 THEN 1 ELSE 0 END) AS QuestionVotes FROM Votes v JOIN Posts p ON v.PostId=p.Id WHERE UserId = ##UserId##;