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