We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
WITH RN AS
(SELECT
ROW_NUMBER() OVER(ORDER BY LAT_N) AS ROW_N,
LAT_N
FROM STATION),
MED AS
(SELECT
COUNT(*) AS TOTAL
FROM RN)
SELECT
ROUND(
CASE
WHEN MOD(M.TOTAL,2)<>0 THEN
(SELECT LAT_N FROM RN WHERE ROW_N=(SELECT (M.TOTAL+1)*0.5))[](https://)
ELSE
(
(SELECT LAT_N FROM RN WHERE ROW_N=(SELECT M.TOTAL*0.5))+
(SELECT LAT_N FROM RN WHERE ROW_N=(SELECT (M.TOTAL*0.5)+1))
)/2
END
,4) AS MEDIAN
FROM MED M
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 20
You are viewing a single comment's thread. Return to all comments →
WITH RN AS (SELECT ROW_NUMBER() OVER(ORDER BY LAT_N) AS ROW_N, LAT_N FROM STATION),
MED AS (SELECT COUNT(*) AS TOTAL FROM RN) SELECT ROUND( CASE WHEN MOD(M.TOTAL,2)<>0 THEN (SELECT LAT_N FROM RN WHERE ROW_N=(SELECT (M.TOTAL+1)*0.5))[](https://) ELSE ( (SELECT LAT_N FROM RN WHERE ROW_N=(SELECT M.TOTAL*0.5))+ (SELECT LAT_N FROM RN WHERE ROW_N=(SELECT (M.TOTAL*0.5)+1)) )/2 END ,4) AS MEDIAN FROM MED M