Task: Text to Code
Input (English): SQL: SELECT name , Count ( * ) FROM aircraft GROUP BY name
Feedback: It should display number of corresponding rows for each airline id in flight table .
Output (English): SELECT T2.name ,  count(*) FROM Flight AS T1 JOIN Aircraft AS T2 ON T1.aid  =  T2.aid GROUP BY T1.aid