Cancel

Weather Observation Station 13

Posted May 31, 2020 2020-05-31T20:00:00+09:00 by HyunMin Kim

URL : https://www.hackerrank.com/challenges/weather-observation-station-13/problem
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.
MySQL Solution

select round(sum(lat_n),4)
from station
where lat_n between 38.7880 and 137.2345

This post is licensed under CC BY 4.0 by the author.