CREATE TABLE buildings (id NUMBER, name CLOB, city CLOB, height NUMBER, stories NUMBER, status CLOB)
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 office_locations (building_id NUMBER, company_id NUMBER, move_in_year NUMBER)

Show the industries shared by companies whose headquarters are 'USA' and companies whose headquarters are '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"