[해커랭크 SQL] Aggregation - Weather Observation Station 2

❓ Question
https://www.hackerrank.com/challenges/weather-observation-station-2

Weather Observation Station 2 | HackerRank

❗ Answer

SELECT ROUND(SUM(lat_n),2), ROUND(SUM(long_w),2)
    FROM station;

📌 Discussion

• 모든 lat_n과 long_w를 각각 합친 후 ROUND로 반올림하여 소수점 둘째자리까지 표현한다.