2017-04-07 20:17:38 -05:00
|
|
|
-- Author: Rodney Shaghoulian
|
2018-07-27 16:45:56 -07:00
|
|
|
-- Github: github.com/RodneyShag
|
|
|
|
|
-- HackerRank: hackerrank.com/RodneyShag
|
2017-04-07 20:17:38 -05:00
|
|
|
|
|
|
|
|
SELECT SUM(CITY.POPULATION)
|
|
|
|
|
FROM CITY, COUNTRY
|
|
|
|
|
WHERE CITY.COUNTRYCODE = COUNTRY.CODE AND COUNTRY.CONTINENT = 'Asia';
|
