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.


Q&A for those who study, teach, research and apply economics and econometrics

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 meta site
loading Hold tight while we fetch your results