0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

-- Enter Query Title
-- Enter Query Description

WITH Rankings AS (
  SELECT 
    Id,
    Reputation,
    Ranking = ROW_NUMBER() OVER(ORDER BY Reputation DESC)
  FROM
    Users
)
, Counts AS (
  SELECT
    Count = COUNT(*)
  FROM
    Users
), FilteredUsers AS (
  SELECT
    Id, Reputation, CAST(Ranking AS decimal(10, 5)) / (SELECT Count FROM Counts) AS Percentile
  FROM
    Rankings
)


SELECT
  COUNT(*) AS NumberOfUsers,
  MIN(Reputation) AS MinimumReputation,
  MAX(Reputation) AS MaximumReputation,
  SUM(Reputation) AS CombinedReputation
FROM
  FilteredUsers
WHERE
  Percentile > ##ExcludingTopPercent## / 100.0

fork query

created dec 15 10 Oak