CREATE TABLE table_name_35 (principal_victims VARCHAR, nat VARCHAR, where_sunk VARCHAR)

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