I want to know the lowest oppose rate among the candidates.
select oppose_rate from candidate order by oppose_rate limit 1
Which candidate got this lowest oppose rate?
select candidate_id from candidate order by oppose_rate limit 1
Hmm, which poll source did this candidate belong to?
select poll_source from candidate order by oppose_rate limit 1