What was the gender for the integrated authority with a roll of 142?
CREATE TABLE table_name_15 (gender VARCHAR, authority VARCHAR, roll VARCHAR)
SELECT gender FROM table_name_15 WHERE authority = "integrated" AND roll = 142
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_15 (gender VARCHAR, authority VARCHAR, roll VARCHAR) Question: What was the gender for the integrated authority with a roll of 142? [/INST] SELECT gender FROM table_name_15 WHERE authority = "integrated" AND roll = 142 </s>