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