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

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

Weather Observation Station 13 | HackerRank

❗ Answer

SELECT ROUND(SUM(lat_n),4)
    FROM station
    WHERE lat_n BETWEEN 38.7880 AND 137.2345;

📌 Discussion

• WHERE 절에서 BETWEEN으로 범위 조건을 걸어준다.