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