Please see github.com/anusha-murali for all of my repositories.
Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is “JPN”.
The CITY table is described as follows:
SELECT SUM(POPULATION)
FROM CITY
WHERE COUNTRYCODE = 'JPN';