Q&A for developers and researchers interested in open data
with a as ( select p.id, sum(case when v.votetypeid = 2 then 1 else 0 end) as upvotes, sum(case when v.votetypeid = 3 then 1 else 0 end) as downvotes from posts p full outer join votes v on p.id = v.PostId where p.PostTypeId = 2 and v.votetypeid in (2,3) --, p.ParentID = ##ParentQuestion:int?6095## group by p.id ) select upvotes, downvotes, count(id) from a group by upvotes, downvotes order by upvotes,downvotes