728x90
❓ Question
https://www.hackerrank.com/challenges/weather-observation-station-14
❗ Answer
SELECT ROUND(MAX(lat_n),4)
FROM station
WHERE lat_n < 137.2345;
📌 Discussion
- WHERE 절에서 조건을 주고 MAX값을 추출 후 ROUND로 반올림
'SQL 문제풀이' 카테고리의 다른 글
[해커랭크 SQL] Aggregation - Weather Observation Station 16 (0) | 2023.08.25 |
---|---|
[해커랭크 SQL] Aggregation - Weather Observation Station 15 (0) | 2023.08.25 |
[해커랭크 SQL] Aggregation - Weather Observation Station 13 (0) | 2023.08.25 |
[해커랭크 SQL] Aggregation - Weather Observation Station 2 (0) | 2023.08.25 |
[해커랭크 SQL] Aggregation - Top Earners (0) | 2023.08.25 |