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

Show aircraft names and number of flights for each aircraft with a bar chart, and sort in ascending by the y-axis.
SELECT name, COUNT(*) FROM flight AS T1 JOIN aircraft AS T2 ON T1.aid = T2.aid GROUP BY T1.aid ORDER BY COUNT(*)
SELECT "name", COUNT(*) FROM "flight" AS "T1" JOIN "aircraft" AS "T2" ON "T1"."aid" = "T2"."aid" GROUP BY "T1"."aid" ORDER BY COUNT(*) NULLS FIRST