Show the industries shared by companies whose headquarters are "USA" and companies whose headquarters are "China".
CREATE TABLE Companies (Industry VARCHAR, Headquarters VARCHAR)
SELECT Industry FROM Companies WHERE Headquarters = "USA" INTERSECT SELECT Industry FROM Companies WHERE Headquarters = "China"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Companies (Industry VARCHAR, Headquarters VARCHAR) Question: Show the industries shared by companies whose headquarters are "USA" and companies whose headquarters are "China". [/INST] SELECT Industry FROM Companies WHERE Headquarters = "USA" INTERSECT SELECT Industry FROM Companies WHERE Headquarters = "China" </s>