SCHEMA:
CREATE TABLE customers (state VARCHAR)
USER:
How many customers in state of CA?

QUERY:
SELECT COUNT(*) FROM customers WHERE state = "CA"