728x90
728x90
Problem
Query the smallest Northern Latitude (LAT_N) from STATION that is greater than 38.7780 . Round your answer to 4 decimal places.
-> 38.7780 보다 큰 lat_n 중에서 가장 작은 값을 소수점 4자리에서 반올림하여 출력하시오.
Answer
select round(min(lat_n),4)
from station
where lat_n > 38.7780
728x90
728x90
'Language > SQL' 카테고리의 다른 글
[HackerRank][SQL][Aggregation] Weather Observation Station 18 - 컴도리돌이 (0) | 2022.05.25 |
---|---|
[HackerRank][SQL][Aggregation] Weather Observation Station 17 - 컴도리돌이 (0) | 2022.05.24 |
[HackerRank][SQL] Weather Observation Station 15 - 컴도리돌이 (0) | 2022.05.22 |
[HackerRank][SQL] Weather Observation Station 14 - 컴도리돌이 (0) | 2022.05.21 |
[HackerRank][SQL] Weather Observation Station 13 - 컴도리돌이 (0) | 2022.05.20 |