data_yep

[문제]  [MySQL]SELECT SUM(C.POPULATION)FROM CITY AS C INNER JOIN COUNTRY AS CO ON C.CountryCode = CO.CodeWHERE CO.CONTINENT = 'Asia'

[문제]  [MySQL]WITH LAT_prnk AS ( SELECT LAT_N , PERCENT_RANK() OVER (ORDER BY LAT_N) AS p_rnk FROM STATION)SELECT ROUND(LAT_N, 4)FROM LAT_prnkWHERE p_rnk = 0.5

[문제]  [MySQL]SELECT ROUND(SQRT(POWER(MAX(LAT_N) - MIN(LAT_N), 2) + POWER(MAX(LONG_W) - MIN(LONG_W), 2)), 4) AS OutputFROM STATION

[문제]  [MySQL]SELECT ROUND(ABS(MAX(LAT_N) - MIN(LAT_N)) + ABS(MAX(LONG_W) - MIN(LONG_W)), 4) AS OutputFROM STATION

[문제]  [MySQL]SELECT ROUND(LONG_W, 4) AS OutputFROM STATIONWHERE LAT_N = (SELECT MIN(LAT_N) FROM STATION WHERE LAT_N > 38.7780)

[문제]  [MySQL]SELECT ROUND(MIN(LAT_N), 4) AS OutputFROM STATIONWHERE LAT_N > 38.7780

[문제]  [MySQL]SELECT ROUND(LONG_W, 4) AS OutputFROM STATIONWHERE LAT_N

[문제]  [MySQL]SELECT ROUND(MAX(LAT_N), 4) AS OutputFROM STATIONWHERE LAT_N

[문제]  [MySQL]SELECT ROUND(SUM(LAT_N), 4) AS OutputFROM STATIONWHERE LAT_N > 38.7880 AND LAT_N

[문제]  [MySQL]SELECT ROUND(SUM(LAT_N), 2) AS lat , ROUND(SUM(LONG_W), 2) AS lonFROM STATION