[Hacker Rank]SQL Basic 'Weather Observation Station 19 '(Medium)

 

https://www.hackerrank.com/challenges/weather-observation-station-19/problem?isFullScreen=true

Weather Observation Station 19 | HackerRank

SELECT ROUND(
    SQRT(
        POWER(MAX(LAT_N)- MIN(LAT_N), 2) 
    + POWER(MAX(LONG_W) - MIN(LONG_W),2)
    ), 4
) AS euclidean_distance
FROM STATION;

 

POINT!

1) SQRT() 함수

: 제곱근 (√) 을 계산하는 함수

SELECT SQRT(16);  -- 결과: 4
SELECT SQRT(2);   -- 결과: 1.414213...

 

2) POWER() 함수

거듭제곱을 계산하는 함수

SELECT POWER(2, 3);   -- 결과: 8   (2^3)
SELECT POWER(9, 0.5); -- 결과: 3   (9^(1/2) = √9)