CREATE TABLE table_45307 ("Date" TEXT, "Ship" TEXT, "Type" TEXT, "Nationality" TEXT, "Tonnage GRT" FLOAT, "Fate" TEXT)

what is the fate when the nationality is french and the ship is pierre lott?
SELECT "Fate" FROM table_45307 WHERE "Nationality" = 'french' AND "Ship" = 'pierre lott'
SELECT "Fate" FROM "table_45307" WHERE "Nationality" = 'french' AND "Ship" = 'pierre lott'