[해커랭크/MySQL] 41. Weather Observation Station 15

👉 https://www.hackerrank.com/challenges/weather-observation-station-15/problem?isFullScreen=true

Weather Observation Station 15 | HackerRank

---

🤔 문제 분석

1. Query the Western Longitude (LONG_W) for the largest Northern Latitude (LAT_N) in STATION that is less than 137.2345.

2. Round your answer to  decimal places.

 

💡 풀이

SELECT ROUND(LONG_W, 4)
FROM STATION
WHERE LAT_N < 137.2345
ORDER BY LAT_N DESC
LIMIT 1