order the candidate table by support rate from high to the low.
select * from candidate order by support_rate desc
what is the name of the candidate in first place?
select t1.name from people as t1 join candidate as t2 on t1.people_id = t2.people_id order by t2.support_rate desc limit 1
show the gender as well.
select t1.name, t1.sex from people as t1 join candidate as t2 on t1.people_id = t2.people_id order by t2.support_rate desc limit 1