what is the fate when the nationality is french and the ship is pierre lott?
CREATE TABLE "table" (
  "date" text,
  "ship" text,
  "type" text,
  "nationality" text,
  "tonnage_grt" real,
  "fate" text
);
SELECT "fate" FROM "table" WHERE "nationality"='french' AND "ship"='pierre lott';