SELECT count(*) FROM customer WHERE active = '1'
How many customers have an active value of 1?
SELECT count ( * ) FROM customer WHERE active = '1 '
select count ( * ) from customer where active = value
How many customers have an active value of 1 ?