[Medium] Weather Observation Station 20

 

Weather Observation Station 20 | HackerRank

 

문제 조건

북부 위도(LAT_N)의 중앙값을 출력하시오 

 

문제 풀이

WITH TEMP AS(
  SELECT LAT_N,
        PERCENT_RANK() OVER(ORDER BY LAT_N) AS PERCENT
  FROM STATION)
  
SELECT ROUND(LAT_N,4)
FROM TEMP
WHERE PERCENT = 0.5