CREATE TABLE table_name_74 (unit VARCHAR, type VARCHAR, origin VARCHAR)

What is the unit for a submarine type ship from Norway?
SELECT unit FROM table_name_74 WHERE type = "submarine" AND origin = "norway"
SELECT "unit" FROM "table_name_74" WHERE "norway" = "origin" AND "submarine" = "type"