SQL
[해커랭크] Weather Observation Station 20
주스 JUICE
2023. 7. 21. 17:38
728x90
[해커랭크] Weather Observation Station 20
Weather Observation Station 20 | HackerRank
Query the median of Northern Latitudes in STATION and round to 4 decimal places.
www.hackerrank.com
못풀어서 다른 블로그 참고..
https://blog.naver.com/pbgg8002/222978260148
[SQL 오답노트] HackerRank 문제 풀이 19 (Weather Observation Station 20) feat. Aggregation 끝😎
Weather Observation Station 20 문제 A median is defined as a number separating the higher half o...
blog.naver.com
select round(LAT_N, 4)
from station
order by LAT_N
limit 249, 1728x90