Table: ship_fate
Columns: date
ship
type
nationality
tonnage_grt
fate

Question: what is the fate when the nationality is french and the ship is pierre lott?
SQL: SELECT "fate" FROM ship_fate WHERE "nationality" = 'french' AND "ship" = 'pierre lott'

Question: what is the ship with the date of 28.1.1915?
SQL: SELECT "ship" FROM ship_fate WHERE "date" = '28.1.1915'

Question: what is the nationality when the ship is willerby?
SQL: SELECT "nationality" FROM ship_fate WHERE "ship" = 'willerby'

Question: what is the least tonnage grt when the nationality is british and the ship is kidalton?
SQL: SELECT MIN("tonnage_grt") FROM ship_fate WHERE "nationality" = 'british' AND "ship" = 'kidalton'