0

Please login or register to vote for this query.

(click on this box to dismiss)

Find the highest-rep users whose combined reputation is more than X% of the total user reputation. Let's make Pareto proud.

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

-- Elite Users: Those who hold > X% of all Reputation
-- Find the highest-rep users whose combined reputation
-- is more than X% of the total user reputation.
-- Let's make Pareto proud.

select count(*) 
from(
select  Reputation,Id 
from Users

where Reputation > 100000 and Reputation < 110000

)as t1

fork query

edited nov 15 19 fhw

created jun 14 10 cwalker77