Table schema:
CREATE TABLE ship (disposition_of_ship VARCHAR)

Question: How many ships ended up being 'Captured'?
SQL: SELECT COUNT(*) FROM ship WHERE disposition_of_ship = 'Captured'