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 for active researchers, academics and students of physics

-- 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.

DECLARE @MyAnswerUpped       int = 0; -- +10

-- SELECT
    --@MyAnswerUpped = COUNT(*)
    --select count(*) *10 as AnsRep, max(t1.Reputation) as TotRep ,t1.Id
    select avg(RepRatio) from
(
    select count(*) *10.0 / max(t1.Reputation) as RepRatio ,t1.Id
FROM Posts

    INNER JOIN Votes ON Posts.Id = Votes.PostId 
      and Votes.VoteTypeId = 2 and Posts.PostTypeId = 2
    INNER JOIN (
select  Id, Reputation 
from Users

where Reputation > 100000 and Reputation < 110000

)as t1 ON t1.Id = Posts.OwnerUserId 

group by t1.Id
    
    )as tratio

fork query

edited nov 15 19 fhw

created jun 14 10 cwalker77