[해커랭크] Weather Observation Station 2

https://www.hackerrank.com/challenges/weather-observation-station-2/problem?isFullScreen=true 

Weather Observation Station 2 | HackerRank

 

LAT_N과 LONG_W를 각각 sum하고 round를 하는 구조

요구한대로 각각 lat, lon이라는 별칭을 지어줬다

 

select round(sum(LAT_N), 2) as lat, round(sum(LONG_W),2) as lon
from station