SELECT count(*) FROM address WHERE district  =  'California'
How many addresses are in the district of California?
SELECT count ( * ) FROM address WHERE district = 'California '
select count ( * ) from address where district = value
How many addresses are in the district of California ?