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 id of the candidate who got the lowest oppose rate.
SELECT candidate_id FROM candidate ORDER BY oppose_rate LIMIT 1
SELECT "candidate_id" FROM "candidate" ORDER BY "oppose_rate" FETCH FIRST 1 ROWS ONLY