[HackerRank] Population Census

 

LEFT JOIN

SELECT SUM(CITY.population)
FROM CITY
     INNER JOIN COUNTRY ON CITY.CountryCode = COUNTRY.CODE
WHERE COUNTRY.CONTINENT = 'Asia'