[HackerRank] Weather Observation Station 17 오라클 풀이

mndev 2024. 2. 2. 13:40

문제링크

Weather Observation Station 17 | HackerRank

Query the Western Longitude for the smallest value of the Northern Latitudes greater than 38.7780 in STATION and round to 4 decimal places.

www.hackerrank.com

코드

select round(long_w,4)
from station
where lat_n = (select min(lat_n)
              from station
              where lat_n > 38.7780);