Show names for all aircrafts with distances more than the average.
CREATE TABLE Aircraft (
    name VARCHAR,
    distance INTEGER
)
SELECT name FROM Aircraft WHERE distance > (SELECT AVG(distance) FROM Aircraft)
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Show names for all aircrafts with distances more than the average. ### Input: CREATE TABLE Aircraft (
    name VARCHAR,
    distance INTEGER
) ### Response: SELECT name FROM Aircraft WHERE distance > (SELECT AVG(distance) FROM Aircraft)