[해커랭크/SQL] 30. Weather Observation Station 2

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

Weather Observation Station 2 | HackerRank

---

 

🤔 문제 분석

Query the following two values from the STATION table:

1. The sum of all values in LAT_N rounded to a scale of 2 decimal places.
2. The sum of all values in LONG_W rounded to a scale of 2 decimal places.

 

💡 풀이

SELECT ROUND(SUM(LAT_N), 2) AS lat, ROUND(SUM(LONG_W), 2) AS lon
FROM STATION