Extreme Upvoters

0

Please login or register to vote for this query.

(click on this box to dismiss)

Operations Research Meta

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 and 100 reputation*/

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;

Enter Parameters

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