[SQL][HackerRank] Weather Observation Station 14

https://www.hackerrank.com/challenges/weather-observation-station-14/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&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.

 

• query greatest value of LAT_N ==> SELECT MAX(LAT_N)
• truncate answer to 4 decimal places ==> SELECT TRUNCATE(MAX(LAT_N), 4)
• from STATION table ==> FROM STATION
• less than 137.2345 ==> WHERE LAT_N < 137.2345

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