CREATE TABLE office_locations (building_id NUMBER, company_id NUMBER, move_in_year NUMBER)
CREATE TABLE companies (id NUMBER, name CLOB, headquarters CLOB, industry CLOB, sales_billion NUMBER, profits_billion NUMBER, assets_billion NUMBER, market_value_billion CLOB)
CREATE TABLE buildings (id NUMBER, name CLOB, city CLOB, height NUMBER, stories NUMBER, status CLOB)

Which industries have both companies with headquarter in 'USA' and companies with headquarter in 'China'?
SELECT industry FROM companies WHERE headquarters = "USA" INTERSECT SELECT industry FROM companies WHERE headquarters = "China"
SELECT "industry" FROM "companies" WHERE "USA" = "headquarters" INTERSECT SELECT "industry" FROM "companies" WHERE "China" = "headquarters"