Question:

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

The CITY table is described as follows:

Syntax:

SELECT AVG(COLUMN_NAME) FROM table_name

where AVG() is the aggregate function and returns the average of the given numerical colum.

Answer:

select avg(population)) from city
where district = "california"