0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for operations research and analytics professionals, educators, and students

/*Returns the top 100 upvoters, who have cast atleast 1000 upvotes and 5 
downvotes*/

select top 100 Id as [User Link],
               Reputation,
               Upvotes,
               DownVotes, 
               round(cast(Upvotes as float)*100/(Upvotes+ DownVotes),1)
                as UpvotePercentage
  from Users
 where Upvotes >= 1000 and DownVotes >= 5
   and Reputation >= 100
 order by UpvotePercentage desc,Upvotes desc, Reputation;

view current version

edited aug 30 13

created aug 30 13 Eat A Peach