Task: Text to Code
Input (English): find the number of rows in Characteristics table whose characteristic_name equals red
Output (English): SELECT Count ( * ) FROM Characteristics WHERE characteristic_name = "red"