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 numbered as
(
select , count() over() as cnt,
row_number() over(order by LAT_N) as row_num
from station
)
select round(LAT_N, 4)
from numbered
where row_num in ((cnt+1)/2, (cnt+2)/2)
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 numbered as ( select , count() over() as cnt, row_number() over(order by LAT_N) as row_num from station ) select round(LAT_N, 4) from numbered where row_num in ((cnt+1)/2, (cnt+2)/2)