hi, can you show me headquarters that have companies in the banking industry?
select distinct headquarters from company where industry = "Banking"
and can you also show me headquarters that have companies in the oil and gas industry?
select distinct headquarters from company where industry = "Oil and gas"
and can you show me only those headquarters that have both companies in oil and gas as well as banking industry?
select headquarters from company where industry = "Banking" intersect select headquarters from company where industry = "Oil and gas"