What are the names and distances for all airplanes Visualize by bar chart, list by the X-axis in asc.
CREATE TABLE aircraft (
    aid number(9,0),
    name varchar2(30),
    distance number(6,0)
)

CREATE TABLE flight (
    flno number(4,0),
    origin varchar2(20),
    destination varchar2(20),
    distance number(6,0),
    departure_date date,
    arrival_date date,
    price number(7,2),
    aid number(9,0)
)

CREATE TABLE employee (
    eid number(9,0),
    name varchar2(30),
    salary number(10,2)
)

CREATE TABLE certificate (
    eid number(9,0),
    aid number(9,0)
)
SELECT name, distance FROM aircraft ORDER BY name
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 are the names and distances for all airplanes Visualize by bar chart, list by the X-axis in asc. ### Input: CREATE TABLE aircraft (
    aid number(9,0),
    name varchar2(30),
    distance number(6,0)
)

CREATE TABLE flight (
    flno number(4,0),
    origin varchar2(20),
    destination varchar2(20),
    distance number(6,0),
    departure_date date,
    arrival_date date,
    price number(7,2),
    aid number(9,0)
)

CREATE TABLE employee (
    eid number(9,0),
    name varchar2(30),
    salary number(10,2)
)

CREATE TABLE certificate (
    eid number(9,0),
    aid number(9,0)
) ### Response: SELECT name, distance FROM aircraft ORDER BY name