Find the id of the candidate who got the lowest oppose rate.
SELECT Candidate_ID FROM candidate ORDER BY oppose_rate LIMIT 1
lowest oppose rate refers to MIN(oppose_rate); id of the candidate refers to Candidate_ID;