SELECT name, COUNT(*) FROM flight AS T1 JOIN aircraft AS T2 ON T1.aid = T2.aid GROUP BY T1.aid ORDER BY name DESC
Visualize a bar chart for what is the name of each aircraft and how many flights does each one complete?, and display by the x-axis from high to low.
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 certificate (
    eid number(9,0),
    aid number(9,0)
)

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

CREATE TABLE aircraft (
    aid number(9,0),
    name varchar2(30),
    distance number(6,0)
)