Weather Observation Station 19

Weather Observation Station 19 | HackerRank

Query the Euclidean Distance between two points and round to 4 decimal digits.

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

SELECT ROUND(SQRT(POW((a - b), 2) + POW((c - d),2)), 4)

FROM (
    SELECT 
    MAX(LAT_N) a,
    MIN(LAT_N) b,
    MAX(LONG_W) c,
    MIN(LONG_W) d
    FROM STATION
) T
JavaScript
복사