Downvote percentages for users within a specific rep range

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

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

-- Returns a list of up- and downvote totals (and downvote percentages)
-- for users within a specified reputation range.

Select
Id as [User Link], Reputation, UpVotes, Downvotes, Round(((Cast((Downvotes*100) AS float))/(Cast ((Upvotes+Downvotes) as float))),2) as PercentDownvotes 
From Users
Where Reputation >= ##MinReputation## and Reputation<= ##MaxReputation## and (UpVotes + Downvotes > 0)
Order by PercentDownvotes Desc

Enter Parameters

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