Database: store_1
Question: How many customers are from California?
SQL:
SELECT count(*) FROM customers WHERE state = "CA";