show the name of all candidates with their support and oppose percentages.
select t1.name, t2.support_rate, t2.oppose_rate from people as t1 join candidate as t2 on t1.people_id = t2.people_id
just show those whose support percentage is higher than their oppose rate.
select t1.name, t2.support_rate, t2.oppose_rate from people as t1 join candidate as t2 on t1.people_id = t2.people_id where t2.support_rate > t2.oppose_rate
no need to show the support and oppose rates.
select t1.name from people as t1 join candidate as t2 on t1.people_id = t2.people_id where t2.support_rate > t2.oppose_rate
how about those whose support percentage is lower than their oppose rate.
select t1.name from people as t1 join candidate as t2 on t1.people_id = t2.people_id where t2.support_rate < t2.oppose_rate