Q&A for administrators and users of the CiviCRM Constituent Relationship Management software
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