SELECT count(*) FROM customer WHERE active = '1'
Count the number of customers who are active.
SELECT count ( * ) FROM customer WHERE active = '1 '
select count ( * ) from customer where active = value
Count the number of customers who are active .