SELECT party_name FROM party WHERE party_id NOT IN (SELECT party_id FROM Member)
What are the names of parties that have no members?
SELECT party_name FROM party WHERE party_id NOT IN ( SELECT party_id FROM Member )
select party_name from party where party_id not in ( select party_id from member )
What are the names of parties that have no members ?