CREATE TABLE Flight (aid VARCHAR)
CREATE TABLE Aircraft (name VARCHAR, aid VARCHAR)

Show aircraft names and number of flights for each aircraft.
SELECT T2.name, COUNT(*) FROM Flight AS T1 JOIN Aircraft AS T2 ON T1.aid = T2.aid GROUP BY T1.aid
SELECT "T2"."name", COUNT(*) FROM "Flight" AS "T1" JOIN "Aircraft" AS "T2" ON "T1"."aid" = "T2"."aid" GROUP BY "T1"."aid"