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

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

Weather Observation Station 16 | HackerRank

❗ Answer

SELECT ROUND(MIN(lat_n),4)
    FROM station
    WHERE lat_n > 38.7780;

📌 Discussion

• WHERE 절에서 조건을 걸고 최소값에 반올림하여 레코드 추출