find the highest support percentage, lowest consider rate and oppose rate of all candidates.
CREATE TABLE candidate (support_rate INTEGER, consider_rate INTEGER, oppose_rate INTEGER)
SELECT MAX(support_rate), MIN(consider_rate), MIN(oppose_rate) FROM candidate
<s>[INST] Write mssql query to answer the following question given the database schema. 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. [/INST] SELECT MAX(support_rate), MIN(consider_rate), MIN(oppose_rate) FROM candidate </s>