https://www.hackerrank.com/challenges/weather-observation-station-19/problem

📔문제

Consider P1(a,c) and P2(b,d) to be two points on a 2D plane where (a,b) are the respective minimum and maximum values of Northern Latitude (LAT_N) and (c,d) are the respective minimum and maximum values of Western Longitude (LONG_W) in STATION.

Query the Euclidean Distance between points P1 and P2 and format your answer to display decimal digits.

The STATION table is described as follows:

where LAT_N is the northern latitude and LONG_W is the western longitude.

---

🧮분야

• AGGREGATION

---

📃SQL 코드

select round(sqrt(power(max(lat_n)-min(lat_n),2)+power(max(long_w)-min(long_w),2)),4)
from station;

---

📰출력 결과

---

📂고찰

유클리디안 거리는 √(b-a)^2+(d-c)^2으로 구할 수 있다.

그러므로 sqrt()라는 제곱근 함수와 power()라는 제곱 함수를 사용했다.