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.
SELECT round(lat_n,4)
FROM (
SELECT lat_n, ROW_NUMBER() OVER (ORDER BY lat_n) rn,count(*) over() total_rows
FROM station
)
WHERE rn = (
CASE
WHEN MOD(total_rows, 2) = 1 THEN (total_rows + 1) / 2
ELSE ((total_rows / 2) + ((total_rows / 2) + 1)) / 2
END
);
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 →
SELECT round(lat_n,4) FROM ( SELECT lat_n, ROW_NUMBER() OVER (ORDER BY lat_n) rn,count(*) over() total_rows FROM station ) WHERE rn = ( CASE WHEN MOD(total_rows, 2) = 1 THEN (total_rows + 1) / 2 ELSE ((total_rows / 2) + ((total_rows / 2) + 1)) / 2 END );