- Weather Observation Station 15

 Query the Western Longitude (LONG_W) for the largest Northern Latitude (LAT_N) in STATION that is less 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:

select round(long_w,4) from station where round(lat_n,4) < 137.2345 order by lat_n desc limit 1

Compiler Message
Success
Input (stdin)
  • INPUT
Expected Output
  • 117.2465

Post a Comment

Previous Post Next Post