Database: candidate_poll
Question: Find the name of the candidates whose oppose percentage is the lowest for each sex.
SQL:
SELECT t1.name ,  t1.sex ,  min(oppose_rate) FROM people AS t1 JOIN candidate AS t2 ON t1.people_id  =  t2.people_id GROUP BY t1.sex