SELECT company ,  main_industry FROM company WHERE company_id NOT IN (SELECT company_id FROM station_company)
Show company name and main industry without a gas station.
SELECT company , main_industry FROM company WHERE company_id NOT IN ( SELECT company_id FROM station_company )
select company , main_industry from company where company_id not in ( select company_id from station_company )
Show company name and main industry without a gas station .