Database: company_employee
Question: Show the headquarters that have both companies in banking industry and companies in oil and gas industry.
SQL:
SELECT Headquarters FROM company WHERE Industry  =  "Banking" INTERSECT SELECT Headquarters FROM company WHERE Industry  =  "Oil and gas"