[HackerRank] Population Census [문제] [MySQL]SELECT SUM(C.POPULATION)FROM CITY AS C INNER JOIN COUNTRY AS CO ON C.CountryCode = CO.CodeWHERE CO.CONTINENT = 'Asia' SQL/HackerRank 2025.03.07
[HackerRank] Weather Observation Station 20 [문제] [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 SQL/HackerRank 2025.03.07
[HackerRank] Weather Observation Station 19 [문제] [MySQL]SELECT ROUND(SQRT(POWER(MAX(LAT_N) - MIN(LAT_N), 2) + POWER(MAX(LONG_W) - MIN(LONG_W), 2)), 4) AS OutputFROM STATION SQL/HackerRank 2025.03.07
[HackerRank] Weather Observation Station 18 [문제] [MySQL]SELECT ROUND(ABS(MAX(LAT_N) - MIN(LAT_N)) + ABS(MAX(LONG_W) - MIN(LONG_W)), 4) AS OutputFROM STATION SQL/HackerRank 2025.03.07
[HackerRank] Weather Observation Station 17 [문제] [MySQL]SELECT ROUND(LONG_W, 4) AS OutputFROM STATIONWHERE LAT_N = (SELECT MIN(LAT_N) FROM STATION WHERE LAT_N > 38.7780) SQL/HackerRank 2025.03.07
[HackerRank] Weather Observation Station 16 [문제] [MySQL]SELECT ROUND(MIN(LAT_N), 4) AS OutputFROM STATIONWHERE LAT_N > 38.7780 SQL/HackerRank 2025.03.07
[HackerRank] Weather Observation Station 15 [문제] [MySQL]SELECT ROUND(LONG_W, 4) AS OutputFROM STATIONWHERE LAT_N SQL/HackerRank 2025.03.07
[HackerRank] Weather Observation Station 14 [문제] [MySQL]SELECT ROUND(MAX(LAT_N), 4) AS OutputFROM STATIONWHERE LAT_N SQL/HackerRank 2025.03.07
[HackerRank] Weather Observation Station 13 [문제] [MySQL]SELECT ROUND(SUM(LAT_N), 4) AS OutputFROM STATIONWHERE LAT_N > 38.7880 AND LAT_N SQL/HackerRank 2025.03.07
[HackerRank] Weather Observation Station 2 [문제] [MySQL]SELECT ROUND(SUM(LAT_N), 2) AS lat , ROUND(SUM(LONG_W), 2) AS lonFROM STATION SQL/HackerRank 2025.03.07