CREATE TABLE mission (mission_id DECIMAL, ship_id DECIMAL, code TEXT, launched_year DECIMAL, location TEXT, speed_knots DECIMAL, fate TEXT)
CREATE TABLE ship (ship_id DECIMAL, name TEXT, type TEXT, nationality TEXT, tonnage DECIMAL)

What are the type and nationality of ships?
SELECT type, nationality FROM ship
SELECT "type", "nationality" FROM "ship"