Show the id and name of the aircraft with the maximum distance.
CREATE TABLE Aircraft (aid VARCHAR, name VARCHAR, distance VARCHAR)
SELECT TOP 1 aid, name FROM Aircraft ORDER BY distance DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Aircraft (aid VARCHAR, name VARCHAR, distance VARCHAR) Question: Show the id and name of the aircraft with the maximum distance. [/INST] SELECT TOP 1 aid, name FROM Aircraft ORDER BY distance DESC </s>