Q&A for people looking to bypass life's everyday problems with simple tricks
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 as float)/tot ,1), round(cast(rej 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 order by tot desc;