Illustrates the inequal distribution of reputation by calculating the percentage of reputation held by the top x% of users. All users are considered, even those below the 200 point poverty line. I personally thank the top x% for their contributions!
Q&A for anime and manga fans
-- Reputation Inequality -- Illustrates the inequal distribution of reputation by calculating the percentage of reputation held by the top x% of users. All users are considered, even those below the 200 point poverty line. I personally thank the top x% for their contributions! DECLARE @Percentile int = ##Percentile## select CAST(CAST(PercentileTotal as float)/CAST(Total as float)*100 as numeric(6,2)) as ReputationHeldByPercentile from ( select sum(Reputation) as Total, (select sum (Reputation) from (select top (@Percentile) percent Users.Reputation, Users.Id from Users order by Reputation DESC) x ) as PercentileTotal from Users) x