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 --(SELECT MAX(Views) FROM --( --SELECT TOP 50 PERCENT Views FROM Users ORDER BY Views; --AS BottomHalf --) --SELECT COUNT(*) --FROM Users;--10993539 users SELECT Views FROM Users ORDER BY Views DESC;