Which states have both owners and professionals living there?
CREATE TABLE Owners (state VARCHAR); CREATE TABLE Professionals (state VARCHAR)
SELECT state FROM Owners INTERSECT SELECT state FROM Professionals
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Owners (state VARCHAR); CREATE TABLE Professionals (state VARCHAR) Question: Which states have both owners and professionals living there? [/INST] SELECT state FROM Owners INTERSECT SELECT state FROM Professionals </s>