Question:

Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is JPN.

Answer:

SELECT SUM(population) FROM city
where COUNTRYCODE = "jpn"