Task: Text to Code
Input (English): Count the number of customers who are active.
Output (English): SELECT count(*) FROM customer WHERE active = '1'