SELECT T2.name ,  count(*) FROM Flight AS T1 JOIN Aircraft AS T2 ON T1.aid  =  T2.aid GROUP BY T1.aid
What is the name of each aircraft and how many flights does each one complete?
create table flight(
	flno number(4,0) primary key,
	origin varchar2(20),
	destination varchar2(20),
	distance number(6,0),
	departure_date date,
	arrival_date date,
	price number(7,2),
    aid number(9,0),
    foreign key("aid") references `aircraft`("aid"));
create table aircraft(
	aid number(9,0) primary key,
	name varchar2(30),
	distance number(6,0));
create table employee(
	eid number(9,0) primary key,
	name varchar2(30),
	salary number(10,2));
create table certificate(
	eid number(9,0),
	aid number(9,0),
	primary key(eid,aid),
	foreign key("eid") references `employee`("eid"),
	foreign key("aid") references `aircraft`("aid")); 
INSERT INTO flight (FLNO, origin, destination, distance, departure_date, arrival_date, price,aid) VALUES (99.0,'Los Angeles','Washington D.C.',2308.0,'04/12/2005 09:30','04/12/2005 09:40',235.98, 1);
INSERT into aircraft (AID,name,distance) values ('1','Boeing 747-400','8430');
INSERT into employee (EID,name,salary) values ('242518965','James Smith','120433');
INSERT into certificate (EID,AID) values ('11564812','2');