SELECT * FROM ( SELECT COUNT(*) AS TotalUsers, MIN(Views)...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Chess

Q&A for serious players and enthusiasts of chess

SELECT * 
FROM
(
SELECT COUNT(*) AS TotalUsers,
       MIN(Views) AS ViewsMin,
       MAX(Views) AS ViewsMax,
       AVG(Views) AS ViewsMean
       
FROM Users
) Summary_1,
(
SELECT TOP 1 PERCENTILE_DISC(0.5) WITHIN GROUP 
             (ORDER BY Views) OVER() AS ViewsMedian

FROM Users
) Summary_2

Enter Parameters

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