Q&A about the site for those who base their lives on Jewish law and tradition and anyone interested in learning more
select PostId [Post Link], sum(case when VoteTypeId = 2 then 1 else 0 end) helpful, sum(case when VoteTypeId = 3 then 1 else 0 end) unhelpful from PostFeedback f join Posts p on p.Id = PostId where OwnerUserId = ##UserId## group by PostId order by sum(case when VoteTypeId = 2 then 1 else 0 end) desc