Studying data
[HackerRank] Basic Join > Population Census 본문
Given the CITY and COUNTRY tables, query the sum of the populations of all cities where the CONTINENT is 'Asia'.
Note: CITY.CountryCode and COUNTRY.Code are matching key columns.
Input Format
The CITY and COUNTRY tables are described as follows:
[MySQL Solution 1]
SELECT SUM(CITY.POPULATION)
FROM CITY, COUNTRY
WHERE CITY.COUNTRYCODE = COUNTRY.CODE AND COUNTRY.CONTINENT = 'Asia';
[MySQL Solution 2]
SELECT SUM(CITY.POPULATION)
FROM CITY
INNER JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE
WHERE COUNTRY.CONTINENT = 'Asia';
문제 링크:
https://www.hackerrank.com/challenges/asian-population/problem?isFullScreen=true
'SQL' 카테고리의 다른 글
[HackerRank] Basic Join > The Report (0) | 2022.12.31 |
---|---|
[HackerRank] Basic Join > Average Population of Each Continent (0) | 2022.12.31 |
[HackerRank] Aggregation > Weather Observation Station 20 (0) | 2022.12.30 |
[HackerRank] Aggregation > Weather Observation Station 15 (0) | 2022.12.30 |
[HackerRank] Aggregation > Top Earners (0) | 2022.12.29 |
Comments