Table: ship_sms
Columns: date
ship
type
nationality
tonnage_grt

Question: What type has a Date of 8 dec 16, and a Ship of duchess of cornwall?
SQL: SELECT "type" FROM ship_sms WHERE "date" = '8 dec 16' AND "ship" = 'duchess of cornwall'

Question: Which nationality has a Ship of minteh?
SQL: SELECT "nationality" FROM ship_sms WHERE "ship" = 'minteh'

Question: What is the total Tonnage GRT with a Type of cargo ship, and a Nationality of norway?
SQL: SELECT SUM("tonnage_grt") FROM ship_sms WHERE "type" = 'cargo ship' AND "nationality" = 'norway'

Question: Which Date has a Ship of hallbjorg?
SQL: SELECT "date" FROM ship_sms WHERE "ship" = 'hallbjorg'