Q&A for active researchers, academics and students of physics
Select count(VoteTypeId) as 'total votes', SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END) AS 'number of up votes', SUM(CASE WHEN VoteTypeId = 3 THEN 1 ELSE 0 END) AS 'number of down votes' From PostFeedback where postid=11227809