CREATE TABLE table_name_97 (fate VARCHAR2, nationality VARCHAR2, ship VARCHAR2)

what is the fate when the nationality is french and the ship is pierre lott?
SELECT fate FROM table_name_97 WHERE nationality = "french" AND ship = "pierre lott"
SELECT "fate" FROM "table_name_97" WHERE "french" = "nationality" AND "pierre lott" = "ship"