SELECT ( (SELECT MAX(Views) FROM (SELECT TOP 50 PERCENT V...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Artificial Intelligence

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results