Show all headquarters with both a company in banking industry and a company in Oil and gas.
CREATE TABLE company (headquarters VARCHAR, main_industry VARCHAR)
SELECT headquarters FROM company WHERE main_industry = 'Banking' INTERSECT SELECT headquarters FROM company WHERE main_industry = 'Oil and gas'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE company (headquarters VARCHAR, main_industry VARCHAR) Question: Show all headquarters with both a company in banking industry and a company in Oil and gas. [/INST] SELECT headquarters FROM company WHERE main_industry = 'Banking' INTERSECT SELECT headquarters FROM company WHERE main_industry = 'Oil and gas' </s>