When a school has authority of state and a decile greater than 1, what is the roll number?
CREATE TABLE table_name_66 (roll VARCHAR, authority VARCHAR, decile VARCHAR)
SELECT roll FROM table_name_66 WHERE authority = "state" AND decile > 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_66 (roll VARCHAR, authority VARCHAR, decile VARCHAR) Question: When a school has authority of state and a decile greater than 1, what is the roll number? [/INST] SELECT roll FROM table_name_66 WHERE authority = "state" AND decile > 1 </s>