Table schema:
CREATE TABLE address (district VARCHAR)

Question: How many addresses are in the district of California?
SQL: SELECT COUNT(*) FROM address WHERE district = 'California'