CREATE TABLE Aircraft (name VARCHAR, distance INT)

Show names for all aircrafts with distances more than the average.
SELECT name FROM Aircraft WHERE distance > (SELECT AVG(distance) FROM Aircraft)
SELECT "name" FROM "Aircraft" WHERE "distance" > (SELECT AVG("distance") FROM "Aircraft")