본문 바로가기

Language/SQL

[HackerRank][SQL] Weather Observation Station 16 - 컴도리돌이

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.7780