데이터 분석/SQL 연습문제
Weather Observation Station 17 (HackerRank)
중급닌자 연습생
2022. 9. 29. 23:41
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
Query the Western Longitude (LONG_W) where the smallest Northern Latitude (LAT_N) in STATION is greater than 38.7780. Round your answer to 4 decimal places.
풀이
제출한 답
select round(LONG_W, 4)
from station
where LAT_N in (select min(LAT_N) from station where LAT_N > 38.7780)