코딩테스트/해커랭크 SQL

[해커랭크/MySQL] 43. Weather Observation Station 17

Sooyoon Jeong 2023. 4. 10. 22:37

🤔 문제 분석

1. Query the Western Longitude (LONG_W)where the smallest Northern Latitude (LAT_N) in STATION is greater than 38.7780.

2. Round your answer to  decimal places.

 

💡 풀이

SELECT ROUND(LONG_W, 4)
FROM STATION
WHERE LAT_N = (SELECT MIN(LAT_N)
               FROM STATION
               WHERE LAT_N > 38.7780)