Contents

Population Census

   Jan 22, 2023     0 min read

Population Census

문제

Population_Census1.jpg
Population_Census2.jpg

코드

Oracle

SELECT SUM(CITY.POPULATION)
FROM CITY
    INNER JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE
WHERE COUNTRY.CONTINENT = 'Asia';