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