Weather Observation Station 16

 Query the smallest Northern Latitude (LAT_N) from STATION that is greater than . Round your answer to  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.

MySql:

Sol 1:

select round(lat_n,4) from station where round(lat_n,4)>38.7880 order by lat_n limit 1

Sol 2:

SELECT ROUND(MIN(Lat_N), 4)
FROM Station
WHERE Lat_N > 38.7780;

Compiler Message
Success
Input (stdin)
INPUT
Expected Output
38.8526