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

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

Input Format

The CITY table is described as follows:

———-SOLUTION———-

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

You may also like...

Leave a Reply

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