What is the total Tonnage GRT with a Type of cargo ship, and a Nationality of norway?
CREATE TABLE table_name_23 (tonnage_grt INTEGER, type VARCHAR, nationality VARCHAR)
SELECT SUM(tonnage_grt) FROM table_name_23 WHERE type = "cargo ship" AND nationality = "norway"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_23 (tonnage_grt INTEGER, type VARCHAR, nationality VARCHAR) Question: What is the total Tonnage GRT with a Type of cargo ship, and a Nationality of norway? [/INST] SELECT SUM(tonnage_grt) FROM table_name_23 WHERE type = "cargo ship" AND nationality = "norway" </s>