user: ### NOW ANSWER:
Question: What is the unit for a Submarine type ship from Norway?
Columns: ['Vessel', 'Origin', 'Type', 'In service', 'Unit']
Types: ['text', 'text', 'text', 'real', 'text']
Sample row: ['Oliver Hazard Perry class', 'United States', 'Frigate', 2.0, 'Anti-Submarine Unit']
SQL:

assistant: SELECT "Unit" FROM "Table" WHERE "Type" = 'Submarine' AND "Origin" = 'Norway';