HACKERRANK 11일차

Weather Observation Station 16

SELECT ROUND(MIN(LAT_N), 4)
FROM STATION
WHERE LAT_N > 38.7780;

Weather Observation Station 17

틀린 코드

SELECT ROUND(LONG_W, 4)
FROM STATION
WHERE MIN(LAT_N) > 38.7780;

맞는 코드

SELECT ROUND(LONG_W, 4)
FROM STATION
WHERE LAT_N = (SELECT MIN(LAT_N) FROM STATION WHERE LAT_N > 38.7780);

10일차의 WOS15와 비슷한 문제

Weather Observation Station 18

맨하탄 거리

SELECT ROUND(MAX(LAT_N)-MIN(LAT_N)+MAX(LONG_W)-MIN(LONG_W),4)
FROM STATION;

Weather Observation Station 19

유클리드 거리
제곱, 제곱근 -> POWER(), SQRT()

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