Table: zapp_ship_data
Columns: date
ship
nationality
tonnage
fate

Question: What ship has a norway nationality?
SQL: SELECT "ship" FROM zapp_ship_data WHERE "nationality" = 'norway'

Question: What is the fate of the ship on 26 April 1942?
SQL: SELECT "fate" FROM zapp_ship_data WHERE "date" = '26 april 1942'

Question: What is the highest tonnage of the ship from norway?
SQL: SELECT MAX("tonnage") FROM zapp_ship_data WHERE "nationality" = 'norway'