please show me the names of all of the representatives
select name from representative
Now show narrow down the list to just those who have not been involved in an election
select name from representative where representative_id not in ( select representative_id from election )
now show those representatives and what party they are a member of
select name, party from representative where representative_id not in ( select representative_id from election )