SELECT headquarters FROM company WHERE main_industry = 'Banking' INTERSECT SELECT headquarters FROM company WHERE main_industry = 'Oil and gas'
Tunjukkan semua kantor pusat dengan perusahaan di industri perbankan dan perusahaan dalam minyak dan gas.
CREATE TABLE company (headquarters VARCHAR, main_industry VARCHAR)