How many customers who live in California that are retailers?
"retailer" is the cust_type; live in California refers to state = 'CA'
SELECT COUNT(*) FROM customer WHERE cust_type = 'retailer' AND state = 'CA'