Which years have a Decile of 4, an Authority of state, and a Name of mapiu school?
CREATE TABLE table_name_43 (years VARCHAR, name VARCHAR, decile VARCHAR, authority VARCHAR)
SELECT years FROM table_name_43 WHERE decile = 4 AND authority = "state" AND name = "mapiu school"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_43 (years VARCHAR, name VARCHAR, decile VARCHAR, authority VARCHAR) Question: Which years have a Decile of 4, an Authority of state, and a Name of mapiu school? [/INST] SELECT years FROM table_name_43 WHERE decile = 4 AND authority = "state" AND name = "mapiu school" </s>