1. 문제 설명


2. 코드
SELECT SUM(C.POPULATION)
FROM CITY AS C
JOIN COUNTRY AS O ON C.CountryCode = O.Code
WHERE O.CONTINENT = 'Asia';'Programming > SQL' 카테고리의 다른 글
| [HackerRank] Basic Join : Average Population of Each Continent (MySQL) (0) | 2022.02.09 |
|---|---|
| [HackerRank] Basic Select : Employee Salaries (MySQL) (0) | 2022.02.08 |
| [HackerRank] Basic Select : Employee Names (MySQL) (0) | 2022.02.08 |
| [HackerRank] Basic Select : Higher Than 75 Marks (MySQL) (0) | 2022.02.08 |
| [HackerRank] Basic Select : Weather Observation Station 1~12 (MySQL) (0) | 2022.02.03 |