Show aircraft names and number of flights for each aircraft.
return aircraft  ;return names of  #1 ;return flights of  #1 ;return number of  #3 for each  #1 ;return #2 ,  #4
['select', 'project', 'project', 'group', 'union']