Q&A for users of Iota, the open-source cryptocurrency for IoT that does not use a blockchain
DECLARE @UserId int = ##UserId## -- Enter Query Title -- Enter Query Description select a.* --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;