CREATE TABLE flight (flno DECIMAL, origin TEXT, destination TEXT, distance DECIMAL, departure_date TIME, arrival_date TIME, price DECIMAL, aid DECIMAL)
CREATE TABLE aircraft (aid DECIMAL, name TEXT, distance DECIMAL)
CREATE TABLE employee (eid DECIMAL, name TEXT, salary DECIMAL)
CREATE TABLE certificate (eid DECIMAL, aid DECIMAL)

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")