SELECT name FROM Aircraft WHERE distance  >  (SELECT avg(distance) FROM Aircraft)
What are the names of all aircrafts that can cover more distances than average?
SELECT name FROM Aircraft WHERE distance > ( SELECT avg ( distance ) FROM Aircraft )
select name from aircraft where distance > ( select avg ( distance ) from aircraft )
What are the names of all aircrafts that can cover more distances than average ?