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

Return the maximum support rate, minimum consider rate, and minimum oppose rate across 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"