Do 10% of Users Hold 90% of the Reputation on Stack Overflow


Please login or register to vote for this query.

(click on this box to dismiss)

It's commonly said that 10% of the worldwide population have 90% of the wealth. This query aims to check the distribution of wealth (reputation-wise) of users on Stack Overflow to see if there is a correlation.

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

declare @TotalRep bigint
declare @UserCount bigint
declare @Top10RepTotal decimal(18,4)
declare @Bottom90RepTotal decimal(18,4)

select @TotalRep = sum(reputation) from users

select @UserCount = count(1) from users where reputation > 2

select @Top10RepTotal = sum(tmp.rep) from
          (select top(1) percent reputation as rep
           from users
           order by reputation desc) as tmp

select @Bottom90RepTotal = sum(tmp.rep) from
          (select top(99) percent reputation as rep
           from users
           order by reputation) as tmp

select @TotalRep TotalRep,
       @UserCount UserCount,
       @Top10RepTotal Top10RepTotal,
       @Bottom90RepTotal Bottom90RepTotal,
       cast((@Top10RepTotal/@TotalRep)*100 as decimal(18,4)) Top10PercentageOfRep,
       cast((@Bottom90RepTotal/@TotalRep)*100 as decimal(18,4)) Bottom90PercentageOfRep

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results