CREATE TABLE Aircraft (name VARCHAR(255), distance INTEGER)
Show names for all aircrafts with distances more than the average.
    
SQL: SELECT name FROM Aircraft WHERE distance > (SELECT AVG(distance) FROM Aircraft)