Upvotes within x% of Downvotes

0

Please login or register to vote for this query.

(click on this box to dismiss)

wrong, i think

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

select top 20
  id as [User Link],
  UpVotes,
  DownVotes,
  Reputation,
  views as [Profile Views],
  format(creationdate,'MMM d, yyyy') as Joined,
  format(lastaccessdate,'MMM d, yyyy') as [Last Access],
  WebsiteURL,
  Location
from users
where (downvotes+upvotes)>##minvotes:int?50##
  and abs(upvotes-downvotes) / case when upvotes>downvotes 
                                    then upvotes 
                                    else downvotes end>(1-##within:float?0.95##)  --within x%
order by upvotes desc

-- minvotes: Include users with this minimum number of total votes =
-- within: Percentage within even 1:1 =

Enter Parameters

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