Find the name, type, and flag of the ship that is built in the most recent year.
CREATE TABLE ship (name VARCHAR, TYPE VARCHAR, flag VARCHAR, built_year VARCHAR)
SELECT TOP 1 name, TYPE, flag FROM ship ORDER BY built_year DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE ship (name VARCHAR, TYPE VARCHAR, flag VARCHAR, built_year VARCHAR) Question: Find the name, type, and flag of the ship that is built in the most recent year. [/INST] SELECT TOP 1 name, TYPE, flag FROM ship ORDER BY built_year DESC </s>