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(avg(lat_n),4)
From
(
Select Lat_n, row_number() over(order by lat_n asc) as RN,
Count(*) over() as TR
From Station
) as SQ
Where RN = CEIL(TR/2) or RN = Floor(TR/2)+1;
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(avg(lat_n),4) From ( Select Lat_n, row_number() over(order by lat_n asc) as RN, Count(*) over() as TR From Station ) as SQ Where RN = CEIL(TR/2) or RN = Floor(TR/2)+1;