less than 1 minute read

Weather Observation Station 13

Query the sum of Northern Latitudes (LAT_N) from STATION having values greater than 38.7880 and less than 137.2345 . Truncate your answer to decimal places.

Input Format

The STATION table is described as follows:

**My solution **

SELECT round(sum(LAT_N),4)
FROM STATION
WHERE LAT_N > 38.7880 and LAT_N < 137.2345;

Tags:

Categories:

Updated:

Comments