find the highest support percentage, lowest consider rate and oppose rate of all candidates.
CREATE TABLE candidate (
    candidate_id number,
    people_id number,
    poll_source text,
    date text,
    support_rate number,
    consider_rate number,
    oppose_rate number,
    unsure_rate number
)

CREATE TABLE people (
    people_id number,
    sex text,
    name text,
    date_of_birth text,
    height number,
    weight number
)
SELECT MAX(support_rate), MIN(consider_rate), MIN(oppose_rate) FROM candidate
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: find the highest support percentage, lowest consider rate and oppose rate of all candidates. ### Input: CREATE TABLE candidate (
    candidate_id number,
    people_id number,
    poll_source text,
    date text,
    support_rate number,
    consider_rate number,
    oppose_rate number,
    unsure_rate number
)

CREATE TABLE people (
    people_id number,
    sex text,
    name text,
    date_of_birth text,
    height number,
    weight number
) ### Response: SELECT MAX(support_rate), MIN(consider_rate), MIN(oppose_rate) FROM candidate