https://www.hackerrank.com/challenges/weather-observation-station-20/problem

📔문제

A median is defined as a number separating the higher half of a data set from the lower half. Query the median of the Northern Latitudes (LAT_N) from STATION and round your answer to decimal places.

The STATION table is described as follows:

where LAT_N is the northern latitude and LONG_W is the western longitude.

---

🧮분야

• AGGREGATION

---

📃SQL 코드

select round(median(lat_n),4)
from station;

---

📰출력 결과

---

📂고찰

중간값을 구하는 문제였다.
오라클에선 median()함수를 이용해 중간값을 찾을 수 있다.