How many tons was the ship from norway?
CREATE TABLE table_name_14 (tons VARCHAR, nationality VARCHAR)
SELECT COUNT(tons) FROM table_name_14 WHERE nationality = "norway"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_14 (tons VARCHAR, nationality VARCHAR) Question: How many tons was the ship from norway? [/INST] SELECT COUNT(tons) FROM table_name_14 WHERE nationality = "norway" </s>