CREATE TABLE company (company_id NUMBER, rank NUMBER, company CLOB, headquarters CLOB, main_industry CLOB, sales_billion NUMBER, profits_billion NUMBER, assets_billion NUMBER, market_value NUMBER)
CREATE TABLE station_company (station_id NUMBER, company_id NUMBER, rank_of_the_year NUMBER)
CREATE TABLE gas_station (station_id NUMBER, open_year NUMBER, location CLOB, manager_name CLOB, vice_manager_name CLOB, representative_name CLOB)

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" "T1" JOIN "company" "T2" ON "T1"."company_id" = "T2"."company_id" GROUP BY "T1"."company_id"