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?
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
What is the name of each aircraft and how many flights does each one complete ?