CREATE TABLE candidate (Candidate_ID VARCHAR, oppose_rate VARCHAR)

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" NULLS FIRST LIMIT 1