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

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" AS "T1" JOIN "aircraft" AS "T2" ON "T1"."aid" = "T2"."aid" GROUP BY "T1"."aid" ORDER BY COUNT(*) DESC NULLS LAST