CREATE TABLE candidate (name VARCHAR2, people_id VARCHAR2)
CREATE TABLE people (name VARCHAR2, people_id VARCHAR2)

what are the names of people who did not participate in the candidate election.
SELECT name FROM people WHERE NOT people_id IN (SELECT people_id FROM candidate)
SELECT "name" FROM "people" WHERE NOT "people_id" IN (SELECT "people_id" FROM "candidate")