-- Database schema
| candidate : Candidate_ID [ INT ] primary_key , People_ID [ INT ] candidate.People_ID = people.People_ID , Poll_Source [ TEXT ] , Date [ TEXT ] , Support_rate [ INT ] , Consider_rate [ INT ] , Oppose_rate [ INT ] , Unsure_rate [ INT ] | people : People_ID [ INT ] primary_key , Sex [ TEXT ] , Name [ TEXT ] , Date_of_Birth [ TEXT ] , Height [ INT ] , Weight [ INT ] |
-- -- For each sex, what is the name and sex of the candidate with the oppose rate for their sex?

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;