CREATE TABLE table_name_74 (unit VARCHAR(255), type VARCHAR(255), origin VARCHAR(255))
What is the unit for a submarine type ship from Norway?
    
SQL: SELECT unit FROM table_name_74 WHERE type = "submarine" AND origin = "norway"