Show names of parties that does not have any members.
CREATE TABLE party (party_name VARCHAR, party_id VARCHAR); CREATE TABLE Member (party_name VARCHAR, party_id VARCHAR)
SELECT party_name FROM party WHERE NOT party_id IN (SELECT party_id FROM Member)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE party (party_name VARCHAR, party_id VARCHAR); CREATE TABLE Member (party_name VARCHAR, party_id VARCHAR) Question: Show names of parties that does not have any members. [/INST] SELECT party_name FROM party WHERE NOT party_id IN (SELECT party_id FROM Member) </s>