Find the name of the shops that do not hire any employee.
CREATE TABLE shop (name VARCHAR, shop_id VARCHAR); CREATE TABLE hiring (name VARCHAR, shop_id VARCHAR)
SELECT name FROM shop WHERE NOT shop_id IN (SELECT shop_id FROM hiring)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE shop (name VARCHAR, shop_id VARCHAR); CREATE TABLE hiring (name VARCHAR, shop_id VARCHAR) Question: Find the name of the shops that do not hire any employee. [/INST] SELECT name FROM shop WHERE NOT shop_id IN (SELECT shop_id FROM hiring) </s>