show the id of the candidate who got the highest oppose rate.
select candidate_id from candidate order by oppose_rate desc limit 1
how about the one with the lowest oppose rate?
select candidate_id from candidate order by oppose_rate limit 1