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)
SELECT company, main_industry FROM company WHERE NOT company_id IN (SELECT company_id FROM station_company)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE station_company (company VARCHAR, main_industry VARCHAR, company_id VARCHAR); CREATE TABLE company (company VARCHAR, main_industry VARCHAR, company_id VARCHAR) Question: Show company name and main industry without a gas station. [/INST] SELECT company, main_industry FROM company WHERE NOT company_id IN (SELECT company_id FROM station_company) </s>