[SQL 코드카타] 158 ~ 164번 (HackerRank)

158번 weather-observation-station-13

SELECT
    ROUND(SUM(LAT_N),4) AS SUM_LAT_N
FROM
    STATION
WHERE
    LAT_N > 38.7880
    AND LAT_N < 137.2345

 

159번 weather-observation-station-14

SELECT
    TRUNCATE(MAX(LAT_N),4) AS SUM_LAT_N
FROM
    STATION
WHERE
    LAT_N < 137.2345

 

160번 weather-observation-station-15

SELECT 
	(ROUND(LONG_W,4))
FROM 
	STATION 
WHERE 
	LAT_N IN (SELECT max(LAT_N) 
    		FROM STATION 
            	WHERE LAT_N<137.2345)

 

161번 weather-observation-station-16

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

 

162번 weather-observation-station-17

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

 

163번 weather-observation-station-18

> 맨하튼거리 : P(X1, Y1), P(X2, Y2)  -> | X1 - X2 |+| Y1 - Y2 |

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

 

164번 weather-observation-station-19

> 유클리드거리 = SQRT(X^2 + Y^2)

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