[해커랭크/SQL] 33. Weather Observation Station 14

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

Weather Observation Station 14 | HackerRank

---

 

🤔 문제 분석

1. Query the greatest value of the Northern Latitudes (LAT_N) from STATION that is less than 137.2345.

2. Truncate your answer to  decimal places.

 

💡 풀이

SELECT TRUNCATE(MAX(LAT_N), 4)
FROM STATION
WHERE LAT_N < 137.2345