CREATE TABLE station_company (company_id VARCHAR2)
CREATE TABLE company (company VARCHAR2, company_id VARCHAR2)

Show the company name with the number of gas station.
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"