Q&A for developers and users of the secure, private and untraceable cryptocurrency Monero
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