What is the name and distance of every aircraft that can cover a distance of more than 5000 and which at least 5 people can fly?
CREATE TABLE aircraft (
    aid number,
    name text,
    distance number
)

CREATE TABLE flight (
    flno number,
    origin text,
    destination text,
    distance number,
    departure_date time,
    arrival_date time,
    price number,
    aid number
)

CREATE TABLE employee (
    eid number,
    name text,
    salary number
)

CREATE TABLE certificate (
    eid number,
    aid number
)
SELECT T2.name FROM certificate AS T1 JOIN aircraft AS T2 ON T2.aid = T1.aid WHERE T2.distance > 5000 GROUP BY T1.aid ORDER BY COUNT(*) >= 5
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: What is the name and distance of every aircraft that can cover a distance of more than 5000 and which at least 5 people can fly? ### Input: CREATE TABLE aircraft (
    aid number,
    name text,
    distance number
)

CREATE TABLE flight (
    flno number,
    origin text,
    destination text,
    distance number,
    departure_date time,
    arrival_date time,
    price number,
    aid number
)

CREATE TABLE employee (
    eid number,
    name text,
    salary number
)

CREATE TABLE certificate (
    eid number,
    aid number
) ### Response: SELECT T2.name FROM certificate AS T1 JOIN aircraft AS T2 ON T2.aid = T1.aid WHERE T2.distance > 5000 GROUP BY T1.aid ORDER BY COUNT(*) >= 5