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
[{'name': 'Boeing 747-400', 'count(*)': 1}, {'name': 'Boeing 737-800', 'count(*)': 1}, {'name': 'Airbus A340-300', 'count(*)': 2}, {'name': 'Embraer ERJ-145', 'count(*)': 1}, {'name': 'SAAB 340', 'count(*)': 1}, {'name': 'Piper Archer III', 'count(*)': 1}, {'name': 'Lockheed L1011', 'count(*)': 2}, {'name': 'Boeing 757-300', 'count(*)': 1}]