Count the number of addressed in the California district.
SELECT count(*) FROM address WHERE district  =  'California'
Count the number of addresses in the California district refers to COUNT(*) WHERE district = 'California';