Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE certificate ( eid number(9,0), aid number(9,0) )
TABLE: 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) )
TABLE: CREATE TABLE employee ( eid number(9,0), name varchar2(30), salary number(10,2) )
TABLE: CREATE TABLE aircraft ( aid number(9,0), name varchar2(30), distance number(6,0) )

### Question ###
Display a bar chart for what is the name of each aircraft and how many flights does each one complete?, and could you sort by the x axis in desc?

### Accurate SQL ###

SELECT name, COUNT(*) FROM flight AS T1 JOIN aircraft AS T2 ON T1.aid = T2.aid GROUP BY T1.aid ORDER BY name DESC