Database: flight_1
Question: Show names for all aircrafts with distances more than the average.
SQL:
SELECT name FROM Aircraft WHERE distance  >  (SELECT avg(distance) FROM Aircraft)