728x90
Weather Observation Station 16 | HackerRank
Query the smallest of STATION's Northern Latitudes that is greater than 38.7780, and round to 4 decimal places
www.hackerrank.com
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.7780728x90
'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 |
