Task: Text to Code
Input (English): Step 1: find the Headquarters of company table for which Main_Industry equals Banking.
Step 2: find the Headquarters of company table for which Company equals Oil and gas.
Step 3: show the rows that are in both the results of step 1 and the results of step 2
Output (English): SELECT Headquarters FROM company WHERE Main_Industry = "Banking" INTERSECT SELECT Headquarters FROM company WHERE Company = "Oil and gas"