SELECT Candidate_ID FROM candidate ORDER BY oppose_rate LIMIT 1
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 limit value
Find the id of the candidate who got the lowest oppose rate .