Files

8 lines
231 B
SQL

-- Author: Rodney Shaghoulian
-- Github: github.com/RodneyShag
-- HackerRank: hackerrank.com/RodneyShag
SELECT SUM(CITY.POPULATION)
FROM CITY, COUNTRY
WHERE CITY.COUNTRYCODE = COUNTRY.CODE AND COUNTRY.CONTINENT = 'Asia';