Number of posts with upvotes vs. downvotes


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for people who build and repair bicycles, people who train cycling, or commute on bicycles

  COUNT(case VoteTypeId when 2 then 1 else null end) as [Posts with upvotes],
  COUNT(case VoteTypeId when 3 then 1 else null end) as [Posts with downvotes]
FROM Votes
GROUP BY PostId, VoteTypeId

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results