Table: violent_events
Columns: estimate
name
nat
ship_type
principal_victims
where_sunk
date

Question: What ship type was from SE?
SQL: SELECT "ship_type" FROM violent_events WHERE "nat" = 'se'

Question: Who were the victims of the US ship that sank in the Mississippi River near Memphis?
SQL: SELECT "principal_victims" FROM violent_events WHERE "nat" = 'us' AND "where_sunk" = 'mississippi river near memphis'

Question: What was the estimated number of victims for the April 27, 1865 sinking?
SQL: SELECT "estimate" FROM violent_events WHERE "date" = 'april 27, 1865'

Question: Which nation was the ship from that had 372 victims?
SQL: SELECT "nat" FROM violent_events WHERE "estimate" = '372'

Question: What type of ship was the HMSST George?
SQL: SELECT "ship_type" FROM violent_events WHERE "name" = 'hmsst george'