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

--(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;

fork query

edited sep 18 19

created sep 18 19 anonymous