How many CDP stores are there in California?
California is a state; CDP stores refer to StoreID where Type = 'CDP';
SELECT SUM(CASE WHEN State = 'California' AND Type = 'CDP' THEN 1 ELSE 0 END) FROM `Store Locations`