0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in conceptual questions about life and challenges in a world where "cognitive" functions can be mimicked in purely digital environment

SELECT
(
 (SELECT MAX(Views) FROM
   (SELECT TOP 50 PERCENT Views FROM Users ORDER BY Views) AS BottomHalf)
 +
 (SELECT MIN(Views) FROM
   (SELECT TOP 50 PERCENT Views FROM Users ORDER BY Views DESC) AS TopHalf)
) / 2 AS Median

fork query

created sep 18 anonymous