Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment
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