Up and downvotes for site users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

SELECT 
  DisplayName, 
  Reputation, 
  UpVotes, 
  DownVotes, 
  UpVotes+DownVotes as TotalVotes, 
  ROUND(UpVotes*1.0/(DownVotes+UpVotes)*100.0,1) as UpvotePercentage
FROM 
  Users
WHERE 
  UpVotes+DownVotes >250 and 
  Reputation > 1000
ORDER BY 
  ROUND(UpVotes*1.0/(DownVotes+UpVotes)*100.0,1) asc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results