Files
HackerRank-Solutions/SQL/Aggregation/Weather Observation Station 19.sql

12 lines
253 B
SQL

-- Author: Rodney Shaghoulian
-- Github: github.com/RodneyShag
-- HackerRank: hackerrank.com/RodneyShag
SELECT
ROUND(SQRT(
POWER(MAX(LAT_N) - MIN(LAT_N), 2)
+ POWER(MAX(LONG_W) - MIN(LONG_W), 2)
), 4)
FROM
STATION;