select top 100 id [User Link] , UpVotes , DownVotes , rou...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top 100
     id [User Link]
     , UpVotes  
     , DownVotes
     , round(cast(nullif(UpVotes, 0)as float) / cast(nullif(DownVotes, 0)as float) , 0)  "Up / Down Vote Ratio"
     , Reputation 
from users
where  id <> -1 and  Reputation > 10000
order by "Up / Down Vote Ratio" desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results