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

👉Weather Observation Station 17 | HackerRank

Weather Observation Station 17 | HackerRank

---

🤔 문제 분석

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)