Task: Text to Code
Input (English): How many ships ended up being 'Captured'?
Output (English): SELECT count(*) FROM ship WHERE disposition_of_ship  =  'Captured'