Which gender has an Authority of state, Years of 1–8, and a Decile smaller than 10, and a Roll of 36?
CREATE TABLE table_name_76 (gender VARCHAR, roll VARCHAR, decile VARCHAR, authority VARCHAR, years VARCHAR)
SELECT gender FROM table_name_76 WHERE authority = "state" AND years = "1–8" AND decile < 10 AND roll = 36
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_76 (gender VARCHAR, roll VARCHAR, decile VARCHAR, authority VARCHAR, years VARCHAR) Question: Which gender has an Authority of state, Years of 1–8, and a Decile smaller than 10, and a Roll of 36? [/INST] SELECT gender FROM table_name_76 WHERE authority = "state" AND years = "1–8" AND decile < 10 AND roll = 36 </s>