CREATE TABLE people (name VARCHAR, sex VARCHAR, people_id VARCHAR)
CREATE TABLE candidate (people_id VARCHAR)

Find the name of the candidates whose oppose percentage is the lowest for each 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
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"