Query the sum of the populations for all Japanese cities in CITY

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

Input Format

The CITY table is described as follows:

———-SOLUTION———-

SELECT SUM(population) FROM city WHERE countrycode = 'JPN';

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *