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)
CREATE TABLE people (people_id NUMBER, sex CLOB, name CLOB, date_of_birth CLOB, height NUMBER, weight NUMBER)

Find the names of the candidates whose support percentage is lower than their oppose rate.
SELECT t1.name FROM people AS t1 JOIN candidate AS t2 ON t1.people_id = t2.people_id WHERE t2.support_rate < t2.oppose_rate
SELECT "t1"."name" FROM "people" "t1" JOIN "candidate" "t2" ON "t1"."people_id" = "t2"."people_id" AND "t2"."oppose_rate" > "t2"."support_rate"