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 * from SuggestedEditVotes where UserId = @UserId order by 5;*/ select top 200 UserId,acc,rej,tot, round(cast(acc*100 as float)/tot ,1), round(cast(rej*100 as float)/tot ,1) 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 tot desc;