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