CREATE TABLE flight (flno NUMBER, origin VARCHAR2, destination VARCHAR2, distance NUMBER, departure_date DATE, arrival_date DATE, price NUMBER, aid NUMBER)
CREATE TABLE certificate (eid NUMBER, aid NUMBER)
CREATE TABLE employee (eid NUMBER, name VARCHAR2, salary NUMBER)
CREATE TABLE aircraft (aid NUMBER, name VARCHAR2, distance NUMBER)

What is the name of each aircraft and how many flights does each one complete Show bar chart, and sort by the Y in descending please.
SELECT name, COUNT(*) FROM flight AS T1 JOIN aircraft AS T2 ON T1.aid = T2.aid GROUP BY T1.aid ORDER BY COUNT(*) DESC
SELECT "name", COUNT(*) FROM "flight" "T1" JOIN "aircraft" "T2" ON "T1"."aid" = "T2"."aid" GROUP BY "T1"."aid" ORDER BY COUNT(*) DESC