Schema: CREATE TABLE customer (active VARCHAR)
Question: How many customers have an active value of 1?
SQL: SELECT COUNT(*) FROM customer WHERE active = '1'