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 |