The top 100 users in total downvotes received per post.
Q&A about the site for serious players and enthusiasts of chess
-- Most downvoted users -- The top 100 users in total downvotes received per post. select top 100 u.Id as [User Link], u.Reputation, (select count(*) from Posts p where u.Id = p.OwnerUserId) as Posts, (select count(*) from Posts p join Votes v on v.PostId = p.Id where u.Id = p.OwnerUserId and v.VoteTypeId = 2) as Upvotes, (select count(*) from Posts p join Votes v on v.PostId = p.Id where u.Id = p.OwnerUserId and v.VoteTypeId = 3) as Downvotes, ((select count(*) from Posts p join Votes v on v.PostId = p.Id where u.Id = p.OwnerUserId and v.VoteTypeId = 3) + 0.0) / ((select count(*) from Posts p where u.Id = p.OwnerUserId) + 0.0) as DownRatio from Users u where (select count(*) from Posts p where u.Id = p.OwnerUserId) > 100 order by ((select count(*) from Posts p join Votes v on v.PostId = p.Id where u.Id = p.OwnerUserId and v.VoteTypeId = 3) + 0.0) / ((select count(*) from Posts p where u.Id = p.OwnerUserId) + 0.0) desc