How many females are there?
select count ( * ) from people where sex = "F"
How about males?
select count ( * ) from people where sex = "M"
What is the lowest oppose rate that male candidates have?
select min ( oppose_rate ) from people as t1 join candidate as t2 on t1.people_id = t2.people_id where t1.sex = "M"
What's the name of the male candidate that has an oppose rate of 0.32?
select name from people as t1 join candidate as t2 on t1.people_id = t2.people_id where t1.sex = "M" and oppose_rate = 0.32
Can you also show me the lowest oppose rate that female candidates have?
select min ( oppose_rate ) from people as t1 join candidate as t2 on t1.people_id = t2.people_id where t1.sex = "F"
Can you show me the name of that female candidate?
select name from people as t1 join candidate as t2 on t1.people_id = t2.people_id where t1.sex = "F" order by oppose_rate asc limit 1