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"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What is the unit for a submarine type ship from Norway? ### Input: CREATE TABLE table_name_74 (
    unit VARCHAR,
    type VARCHAR,
    origin VARCHAR
) ### Response: SELECT unit FROM table_name_74 WHERE type = "submarine" AND origin = "norway"