CREATE TABLE candidate (Candidate_ID VARCHAR2, oppose_rate VARCHAR2)

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