Database: candidate_poll
Question: Find the names of the candidates whose support percentage is lower than their oppose rate.
SQL:
SELECT t1.name FROM people AS t1 JOIN candidate AS t2 ON t1.people_id  =  t2.people_id WHERE t2.support_rate  <  t2.oppose_rate