How many customers are from California?
select count(*) from customers where state = "CA";