HackerRank-Aggregation-Weather Observation Station 13
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;
Comments