Weather Observation Station 13

Question Link

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 4 decimal places.

The STATION table is described as follows:

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

SELECT TRUNCATE(SUM(lat_n),4) 
FROM Station
WHERE lat_n BETWEEN 38.7880 AND 137.2345

Keep in mind that BETWEEN is inclusive! For this question, it doesn’t matter if we use between or logical operator.