Q&A for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
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 = 31628 group by PostId order by sum(case when VoteTypeId = 3 then 1 else 0 end) desc