What is the highest tonnage for a ship from Great Britain named Newton Ash?
CREATE TABLE table_name_13 (tonnage INTEGER, nationality VARCHAR, ship VARCHAR)
SELECT MAX(tonnage) FROM table_name_13 WHERE nationality = "great britain" AND ship = "newton ash"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_13 (tonnage INTEGER, nationality VARCHAR, ship VARCHAR) Question: What is the highest tonnage for a ship from Great Britain named Newton Ash? [/INST] SELECT MAX(tonnage) FROM table_name_13 WHERE nationality = "great britain" AND ship = "newton ash" </s>