What is the average distance?
select avg(distance) from aircraft
Show the name for all aircrafts with a distance above it.
select name from aircraft where distance > (select avg(distance) from aircraft)