[HackerRank] Weather Observation Station 17

mzzzi·2022년 4월 25일
0

HackerRank SQL

목록 보기
39/52
post-thumbnail

MySQL > Weather Observation Station 17


Query the Western Longitude (LONG_W)where the smallest Northern Latitude (LAT_N) in STATION 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(LONG_W, 4)
FROM STATION
WHERE LAT_N > 38.7780 
ORDER BY LAT_N 
LIMIT 1;
profile
무럭무럭 성장하라🌳

0개의 댓글