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

What are the names of candidates who have a lower support rate than 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" AS "t1" JOIN "candidate" AS "t2" ON "t1"."people_id" = "t2"."people_id" AND "t2"."oppose_rate" > "t2"."support_rate"