CREATE TABLE candidate (support_rate INT, consider_rate INT, oppose_rate INT)

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
SELECT MAX("support_rate"), MIN("consider_rate"), MIN("oppose_rate") FROM "candidate"