What is the largest Decile with Years of 1–8, anAuthority of state, and a Roll of 141?
CREATE TABLE table_name_46 (decile INTEGER, roll VARCHAR, years VARCHAR, authority VARCHAR)
SELECT MAX(decile) FROM table_name_46 WHERE years = "1–8" AND authority = "state" AND roll = 141
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_46 (decile INTEGER, roll VARCHAR, years VARCHAR, authority VARCHAR) Question: What is the largest Decile with Years of 1–8, anAuthority of state, and a Roll of 141? [/INST] SELECT MAX(decile) FROM table_name_46 WHERE years = "1–8" AND authority = "state" AND roll = 141 </s>