[HackerRank] Weather Observation Station 20

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

WITH LAT_prnk AS (
    SELECT LAT_N
         , PERCENT_RANK() OVER (ORDER BY LAT_N) AS p_rnk
    FROM STATION
)

SELECT ROUND(LAT_N, 4)
FROM LAT_prnk
WHERE p_rnk = 0.5