Q&A for professionals and students of engineering
DECLARE @UserId int = ##UserId## -- Enter Query Title -- Enter Query Description select b.Id , b.Score, c.Name , count(case when a. VoteTypeId = 2 then 1 end), count(case when a. VoteTypeId = 3 then 1 end) from PostFeedback a inner join Posts b on a.PostId = b.Id inner join PostTypes c on b.PostTypeId = c.Id where b.OwnerUserId = @UserId group by b.Id , b.Score, c.Name ;