Q&A for professionals and students of engineering
DECLARE @UserId int = ##UserId## -- Enter Query Title -- Enter Query Description --select * from VoteTypes; --select * from PostTypes; select sum(isAccepted) from ( select case when exists (select 1 from Posts b where a.Id = b.AcceptedAnswerId and b.Id = a.ParentId ) then 1 else 0 end isAccepted ,a.* from Posts a where a.PostTypeId = 2 and a.OwnerUserId = @UserId) as w