CREATE TABLE candidate (candidate_id NUMBER, people_id NUMBER, poll_source CLOB, date CLOB, support_rate NUMBER, consider_rate NUMBER, oppose_rate NUMBER, unsure_rate NUMBER)
CREATE TABLE people (people_id NUMBER, sex CLOB, name CLOB, date_of_birth CLOB, height NUMBER, weight NUMBER)

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"