What is the unit for a submarine type ship from Norway?
CREATE TABLE table_name_74 (unit VARCHAR, type VARCHAR, origin VARCHAR)
SELECT unit FROM table_name_74 WHERE type = "submarine" AND origin = "norway"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_74 (unit VARCHAR, type VARCHAR, origin VARCHAR) Question: What is the unit for a submarine type ship from Norway? [/INST] SELECT unit FROM table_name_74 WHERE type = "submarine" AND origin = "norway" </s>