Users with highest downvote to upvote ratio.
Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more
select top 100 row_number() over (order by u.DownVotes * 1.0 / u.UpVotes desc) as '#', u.Id as [User Link], format(u.DownVotes * 1.0 / UpVotes, 'p') as [Evil Ratio], u.UpVotes as [Up], u.DownVotes as [Down], u.Reputation as [Rep], u.LastAccessDate as [Last Access], ( select top 4 t.TagName + ', ' as 'data()' from Posts as q inner join Posts as a on a.ParentId = q.Id inner join PostTags as pt on pt.PostId = q.Id inner join Tags as t on pt.TagId = t.Id where a.OwnerUserId = u.Id and a.PostTypeId = 2 group by TagName order by sum(a.Score) desc for xml path('') ) + ' ...' as [Top Tags] from Users as u where u.DownVotes > 100 order by u.DownVotes * 1.0 / u.UpVotes desc