Occupy Stack Overflow!
Q&A for those who study, teach, research and apply economics and econometrics
-- How Rich Are the 1% (Active Users) -- Occupy Stack Overflow! ;WITH percentile AS ( SELECT NTILE(100) OVER (ORDER BY Reputation DESC) as p, Reputation, DisplayName FROM Users WHERE Reputation >= 200 ), total AS ( SELECT SUM(Reputation) as total FROM percentile ) SELECT 'The ' + CASE p WHEN 1 THEN '1' ELSE '99' END + '%' AS Who, SUM(Reputation) AS Rep, CAST(SUM(Reputation) AS DECIMAL(19,2)) / total.total * 100 AS PctShareOfWealth FROM percentile, total GROUP BY CASE p WHEN 1 THEN '1' ELSE '99' END, total.total