Table schema:
CREATE TABLE customer (active VARCHAR)

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