SELECT company ,  main_industry FROM company WHERE company_id NOT IN (SELECT company_id FROM station_company)
What are the main industries of the companies without gas stations and what are the companies?
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 )
What are the main industries of the companies without gas stations and what are the companies ?