Task: Text to Code
Input (English): SQL: SELECT name , Count ( * ) FROM airport GROUP BY name
Feedback: Make sure to find operating companies in airline industry .
Output (English): SELECT T3.id ,  count(*) FROM operate_company AS T1 JOIN flight AS t2 ON T1.id  =  T2.company_id JOIN airport AS T3 ON T2.airport_id  =  T3.id GROUP BY T3.id