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 * from VoteTypes; --select * from PostTypes; select sum(isAccepted), count(isAccepted), round(cast (sum(isAccepted) as float)/ count(isAccepted),1) 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