SELECT count(*) FROM address WHERE district  =  'California'
Count the number of addressed in the California district.
SELECT count ( * ) FROM address WHERE district = 'California '
select count ( * ) from address where district = value
Count the number of addressed in the California district .