CREATE TABLE aircraft (aid NUMBER, name VARCHAR2, distance NUMBER)
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)

Display a bar chart for what is the name of each aircraft and how many flights does each one complete?
SELECT name, COUNT(*) FROM flight AS T1 JOIN aircraft AS T2 ON T1.aid = T2.aid GROUP BY T1.aid
SELECT "name", COUNT(*) FROM "flight" "T1" JOIN "aircraft" "T2" ON "T1"."aid" = "T2"."aid" GROUP BY "T1"."aid"