[HackerRank] Weather Observation Station 16

mzzzi·2022년 4월 25일
0

HackerRank SQL

목록 보기
38/52
post-thumbnail

MySQL > Weather Observation Station 16


Query the smallest Northern Latitude (LAT_N) from STATION that is greater than 38.7780. Round your answer to decimal places.

Input Format
The STATION table is described as follows:

where LAT_N is the northern latitude and LONG_W is the western longitude.

My Answer


SELECT ROUND(MIN(LAT_N),4)
FROM STATION
WHERE LAT_N > 38.7780 ;
profile
무럭무럭 성장하라🌳

0개의 댓글