Database: candidate_poll
Question: For each sex, what is the name and sex of the candidate with the oppose rate for their 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