Which last names are both used by customers and by staff?
CREATE TABLE Customers (last_name VARCHAR); CREATE TABLE Staff (last_name VARCHAR)
SELECT last_name FROM Customers INTERSECT SELECT last_name FROM Staff
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Customers (last_name VARCHAR); CREATE TABLE Staff (last_name VARCHAR) Question: Which last names are both used by customers and by staff? [/INST] SELECT last_name FROM Customers INTERSECT SELECT last_name FROM Staff </s>