How many addresses are in the district of California?
SELECT count(*) FROM address WHERE district  =  'California'
count addresses in a specific district refers to COUNT(*) WHERE district = 'specified district';