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