How many companies operates airlines in each airport?
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
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
[{'id': 1, 'count(*)': 1}, {'id': 2, 'count(*)': 3}, {'id': 3, 'count(*)': 1}, {'id': 4, 'count(*)': 3}, {'id': 5, 'count(*)': 1}, {'id': 6, 'count(*)': 2}, {'id': 8, 'count(*)': 1}, {'id': 9, 'count(*)': 1}]