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