give me info of all candidates.
select * from candidate
what are their names?
select t1.name from people as t1 join candidate as t2 on t1.people_id = t2.people_id
how about those who were not candidates in the election?
select name from people where people_id not in (select people_id from candidate)