 what is the fate when the nationality is french and the ship is pierre lott?
CREATE TABLE table_name_97 (
    fate VARCHAR,
    nationality VARCHAR,
    ship VARCHAR
)
SELECT fate FROM table_name_97 WHERE nationality = "french" AND ship = "pierre lott"