Median User Reputation

0

Please login or register to vote for this query.

(click on this box to dismiss)

German Language Meta

Q&A about the site for speakers of German wanting to discuss the finer points of the language and translation

SELECT
(
 (SELECT MAX(Reputation) FROM
   (SELECT TOP 50 PERCENT Reputation FROM Users ORDER BY Reputation) AS bottomhalf)
 +
 (SELECT MIN(Reputation) FROM
   (SELECT TOP 50 PERCENT Reputation FROM Users ORDER BY Reputation DESC) AS tophalf)
) / 2 AS Median

Enter Parameters

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