The last 100 users in order of the downvote against / total reputation ratio
Q&A for professional and enthusiast programmers
-- Least downvoted users -- The last 100 users in order of the downvote against / total reputation ratio select top 100 u.Id as [User Link], u.Reputation, count(*) as Downvotes, count(distinct p.Id) as questions, count(*) *100.0 / count(distinct p.Id) as Ratio from Users u join Posts p on u.Id = p.OwnerUserId join Votes v on v.PostId = p.Id where u.Reputation > 1 and v.VoteTypeId = 3 and p. PostTypeId=1 group by u.Id, u.Reputation having count(*)>1 and count(distinct p.Id)>1 order by count(*) *100.0 / count(distinct p.Id) desc