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

Show aircraft names and number of flights for each aircraft with a bar chart, list by the Y in descending.
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