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)
### Context: CREATE TABLE Aircraft (name VARCHAR, distance INTEGER) ### Question: Show names for all aircrafts with distances more than the average. ### Answer: SELECT name FROM Aircraft WHERE distance > (SELECT AVG(distance) FROM Aircraft)