Task: Text to Code
Input (English): SQL: SELECT Count ( * ) FROM battle WHERE result = "Captured"
Feedback: Take ship table and disposition of ship in place of battle table and result .
Output (English): SELECT count(*) FROM ship WHERE disposition_of_ship  =  'Captured'