문제 link
https://www.hackerrank.com/challenges/weather-observation-station-20/problem
Code link
https://github.com/JamesJung01/Hackerrank_sql/blob/main/02_Medium/Weather_Observation_Station_20.sql
SELECT ROUND(s.LAT_N,4) AS median FROM STATION AS s WHERE (SELECT COUNT(LAT_N) FROM STATION WHERE Lat_N < s.LAT_N) = (SELECT COUNT(LAT_N) FROM STATION WHERE LAT_N > s.LAT_N)