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