728x90
Problem
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.
-> lat_n 이 38.7780보다 큰 lat_n중에서 가장 작은 값을 가진 long_w를 소수점 4번째에서 반올림하여 출력하시오.
select round(long_w,4)
from station
where lat_n > 38.7780
order by lat_n limit 1
'Language > SQL' 카테고리의 다른 글
[HackerRank][SQL][Aggregation] Weather Observation Station 19 - 컴도리돌이 (0) | 2022.05.26 |
---|---|
[HackerRank][SQL][Aggregation] Weather Observation Station 18 - 컴도리돌이 (0) | 2022.05.25 |
[HackerRank][SQL] Weather Observation Station 16 - 컴도리돌이 (0) | 2022.05.23 |
[HackerRank][SQL] Weather Observation Station 15 - 컴도리돌이 (0) | 2022.05.22 |
[HackerRank][SQL] Weather Observation Station 14 - 컴도리돌이 (0) | 2022.05.21 |