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 RankedStations AS (
SELECT LAT_N,
ROW_NUMBER() OVER (ORDER BY LAT_N) AS RowAsc,
ROW_NUMBER() OVER (ORDER BY LAT_N DESC) AS RowDesc
FROM STATION
)
SELECT ROUND(
AVG(LAT_N), 4
) AS median
FROM RankedStations
WHERE RowAsc = RowDesc
OR RowAsc + 1 = RowDesc;
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 RankedStations AS ( SELECT LAT_N, ROW_NUMBER() OVER (ORDER BY LAT_N) AS RowAsc, ROW_NUMBER() OVER (ORDER BY LAT_N DESC) AS RowDesc FROM STATION ) SELECT ROUND( AVG(LAT_N), 4 ) AS median FROM RankedStations WHERE RowAsc = RowDesc OR RowAsc + 1 = RowDesc;