Query the total population of all cities in CITY where District is California

Query the total population of all cities in CITY where District is California.

Input Format

The CITY table is described as follows:

———-SOLUTION———-

SELECT SUM(population) FROM city WHERE district = 'California';

You may also like...

Leave a Reply

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