Show names for all aircrafts with distances more than the average.
CREATE TABLE Aircraft (name VARCHAR, distance INTEGER)
SELECT name FROM Aircraft WHERE distance > (SELECT AVG(distance) FROM Aircraft)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Aircraft (name VARCHAR, distance INTEGER) Question: Show names for all aircrafts with distances more than the average. [/INST] SELECT name FROM Aircraft WHERE distance > (SELECT AVG(distance) FROM Aircraft) </s>