Redmon-related with more than 0.5% of total reputation

0

Please login or register to vote for this query.

(click on this box to dismiss)

Genealogy and Family History Meta

Q&A about the site for expert genealogists and people interested in genealogy or family history

-- Stolen from http://data.stackexchange.com/stackoverflow/query/3543/elite-users-those-who-hold-x-of-all-reputation
-- 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 @TotalReputation int
select @TotalReputation = sum(Reputation)
from Users


select
  *
from
  Users 
where
  Reputation > @TotalReputation * (0.05 / 100.0)
  and (
     Location   like '%Redmond%' 
  or Location   like '%WA%'
  or WebsiteUrl like '%csharp%'
  or WebsiteUrl like '%mvp%'
  or WebsiteUrl like '%microsoft%'
  or WebsiteUrl like '%msdn%'
  or AboutMe    like '%microsoft%'
  or AboutMe    like '%msdn%'
  or AboutMe    like '%ASP%'
  or AboutMe    like '%.NET%'
  or AboutMe    like '%C#%'
  )
order by
  Reputation desc

Enter Parameters

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