Lists top 100 users who have highest downvotes/day ratio excluding community user and minimum of 100 votes cast.
Q&A for science fiction and fantasy enthusiasts
select top 100
id [User Link]
, datediff(dd, creationdate, GETDATE() ) "Days"
, round(cast(nullif(DownVotes, 0)as float) / datediff(dd, creationdate, GETDATE()),4) "DownVotes/Day Ratio"
where id <> -1 and DownVotes > 100
order by "Downvotes/Day Ratio" desc