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 ROW_NUMS AS (
SELECT
LAT_N,
ROW_NUMBER() OVER(ORDER BY LAT_N) AS ROW_NUM,
COUNT(*) OVER() AS TOTAL_NO_ROWS
FROM STATION
),
MID_VALS AS(
SELECT LAT_N
FROM ROW_NUMS
WHERE ROW_NUM IN (
FLOOR((TOTAL_NO_ROWS+1)/2),
CEIL((TOTAL_NO_ROWS+1)/2)
)
)
SELECT ROUND(AVG(LAT_N), 4) AS MEDIAN
FROM MID_VALS;
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 ROW_NUMS AS ( SELECT LAT_N, ROW_NUMBER() OVER(ORDER BY LAT_N) AS ROW_NUM, COUNT(*) OVER() AS TOTAL_NO_ROWS FROM STATION ), MID_VALS AS( SELECT LAT_N FROM ROW_NUMS WHERE ROW_NUM IN ( FLOOR((TOTAL_NO_ROWS+1)/2), CEIL((TOTAL_NO_ROWS+1)/2) ) ) SELECT ROUND(AVG(LAT_N), 4) AS MEDIAN FROM MID_VALS;