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*/

select top 100 DisplayName 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
 order by upvotepercentage desc,Upvotes desc, Reputation;

Enter Parameters

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