Mostrar os nomes de todas as aeronaves com distâncias superiores à média.
CREATE TABLE Aircraft (name VARCHAR, distance INTEGER)
SELECT name FROM Aircraft WHERE distance > (SELECT AVG(distance) FROM Aircraft)