For each company id, what are the companies and how many gas stations does each one operate?
SELECT T2.company ,  count(*) FROM station_company AS T1 JOIN company AS T2 ON T1.company_id  =  T2.company_id GROUP BY T1.company_id
SELECT T2.company ,  count(*) FROM station_company AS T1 JOIN company AS T2 ON T1.company_id  =  T2.company_id GROUP BY T1.company_id
[{'Company': 'ExxonMobil', 'count(*)': 2}, {'Company': 'Royal Dutch Shell', 'count(*)': 1}, {'Company': 'PetroChina', 'count(*)': 1}, {'Company': 'Petrobras', 'count(*)': 1}, {'Company': 'BP', 'count(*)': 1}]