SELECT company, main_industry FROM company WHERE NOT company_id IN (SELECT company_id FROM station_company)
Tunjukkan nama perusahaan dan industri utama tanpa pompa bensin.
CREATE TABLE station_company (company VARCHAR, main_industry VARCHAR, company_id VARCHAR); CREATE TABLE company (company VARCHAR, main_industry VARCHAR, company_id VARCHAR)