Top 100 users with highest downvotes per day ratio


Please login or register to vote for this query.

(click on this box to dismiss)

Lists top 100 users who have highest downvotes/day ratio excluding community user and minimum of 100 votes cast.

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

select top 100
     id [User Link]
     , datediff(dd, creationdate, GETDATE() ) "Days"
     , DownVotes  
     , round(cast(nullif(DownVotes, 0)as float) / datediff(dd, creationdate, GETDATE()),4)  "DownVotes/Day Ratio"
from users
where  id <> -1 and DownVotes > 100
order by "Downvotes/Day Ratio" desc

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results