[HackerRank] Weather Observation Station 14

https://www.hackerrank.com/challenges/weather-observation-station-14/problem?isFullScreen=true&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen 

 

Weather Observation Station 14 | HackerRank

 

Query the greatest value of the Northern Latitudes (LAT_N) from STATION that is less than 137.2345. Truncate your answer to 4 decimal places.

Input Format

The STATION table is described as follows:

where LAT_N is the northern latitude and LONG_W is the western longitude.

 

[My Answer]

SELECT ROUND(max(lat_n), 4)
FROM STATION 
WHERE lat_n < 137.2345

역시 round 함수를 쓰고 최대값을 찾는 max를 써줬다. 

아니 왜 까다롭다가 갑자기 난이도가 내려가냐고..