What are the names of parties that do not have delegates in election?
CREATE TABLE election (Party VARCHAR, Party_ID VARCHAR); CREATE TABLE party (Party VARCHAR, Party_ID VARCHAR)
SELECT Party FROM party WHERE NOT Party_ID IN (SELECT Party FROM election)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE election (Party VARCHAR, Party_ID VARCHAR); CREATE TABLE party (Party VARCHAR, Party_ID VARCHAR) Question: What are the names of parties that do not have delegates in election? [/INST] SELECT Party FROM party WHERE NOT Party_ID IN (SELECT Party FROM election) </s>