Task: Text to Code
Input (English): Show all headquarters with both a company in banking industry and a company in Oil and gas.
Output (English): SELECT headquarters FROM company WHERE main_industry  =  'Banking' INTERSECT SELECT headquarters FROM company WHERE main_industry  =  'Oil and gas'