Database: flight_1
Question: What are the names of all aircrafts that can cover more distances than average?
SQL:
SELECT name FROM Aircraft WHERE distance  >  (SELECT avg(distance) FROM Aircraft)