Schema: CREATE TABLE candidate (support_rate INTEGER, consider_rate INTEGER, oppose_rate INTEGER)
Question: find the highest support percentage, lowest consider rate and oppose rate of all candidates.
SQL: SELECT MAX(support_rate), MIN(consider_rate), MIN(oppose_rate) FROM candidate