하루에 하나씩 공부하기
[해커랭크 Aggregation] Weather Observation Station 18 본문
- 문제
맨하튼 거리 구하기
Weather Observation Station 18 | HackerRank
Weather Observation Station 18 | HackerRank
Query the Manhattan Distance between two points, round or truncate to 4 decimal digits.
www.hackerrank.com
- 키포인트
없음
- 쿼리
SELECT ROUND(ABS(MAX(LAT_N)-MIN(LAT_N))+ABS(MAX(LONG_W)-MIN(LONG_W)),4)
FROM STATION;