[해커랭크/MySQL] 42. Weather Observation Station 16

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

 

---

🤔 문제 분석

1. Query the smallest Northern Latitude (LAT_N) from STATION that is greater than .

2. Round your answer to 4 decimal places.

 

💡 풀이

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