Table: violent_events
Columns: estimate
name
nat
ship_type
where_sunk
date

Question: What is the date that a hell ship sunk in the East China Sea?
SQL: SELECT "date" FROM violent_events WHERE "where_sunk" = 'east china sea' AND "ship_type" = 'hell ship'

Question: Which nation had a battlecruiser with an estimate of 513?
SQL: SELECT "nat" FROM violent_events WHERE "ship_type" = 'battlecruiser' AND "estimate" = '513'

Question: What is the date that a ship sank in the South Atlantic?
SQL: SELECT "date" FROM violent_events WHERE "where_sunk" = 'south atlantic'

Question: What type of ship was the Shinano?
SQL: SELECT "ship_type" FROM violent_events WHERE "name" = 'shinano'

Question: What nation had a ship named Roma?
SQL: SELECT "nat" FROM violent_events WHERE "name" = 'roma'