find the highest support percentage, lowest consider rate and oppose rate of all candidates.
SELECT max(support_rate) ,  min(consider_rate) ,  min(oppose_rate) FROM candidate
highest support percentage refers to MAX(support_rate); lowest consider rate refers to MIN(consider_rate); oppose rate of all candidates refers to MIN(oppose_rate);