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)
[SQL] SELECT party_name FROM party WHERE NOT party_id IN (SELECT party_id FROM Member) [/SQL]