CREATE TABLE people (people_id NUMBER, sex CLOB, name CLOB, date_of_birth CLOB, height NUMBER, weight NUMBER)
CREATE TABLE candidate (candidate_id NUMBER, people_id NUMBER, poll_source CLOB, date CLOB, support_rate NUMBER, consider_rate NUMBER, oppose_rate NUMBER, unsure_rate NUMBER)

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")