Show company name and main industry without a gas station.
CREATE TABLE station_company (company VARCHAR, main_industry VARCHAR, company_id VARCHAR); CREATE TABLE company (company VARCHAR, main_industry VARCHAR, company_id VARCHAR)
[SQL] SELECT company, main_industry FROM company WHERE NOT company_id IN (SELECT company_id FROM station_company) [/SQL]