Database: gas_company
Question: For each company id, what are the companies and how many gas stations does each one operate?
SQL:
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