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 * from SuggestedEditVotes where UserId = @UserId order by 5;*/ select top 200 UserId,acc,rej,tot, round(cast(acc*100 as float)/tot ,1) accp, round(cast(rej*100 as float)/tot ,1) rejp from ( select UserId, count(case when VoteTypeId = 2 then 1 end) acc, count(case when VoteTypeId = 3 then 1 end) rej, count(VoteTypeId) tot from SuggestedEditVotes --where UserId = @UserId group by UserId ) as e where tot >= 100 order by accp desc;