Tell me the information of all the parties.
select * from party
which parties have delegates in the election?
select party from party where party_id in (select party from election)
Which ones do not?
select party from party where party_id not in (select party from election)