Tell me the companies in the banking industry.
select name from company where industry = "Banking"
Where are their headquarters?
select headquarters from company where industry = "Banking"
Tell me the headquarters that have both companies in the banking industry and companies in the oil and gas industry.
select headquarters from company where industry = "Banking" intersect select headquarters from company where industry = "Oil and gas"