Which name has a Roll larger than 297, and Years of 7–13?
CREATE TABLE table_name_1 (name VARCHAR, roll VARCHAR, years VARCHAR)
SELECT name FROM table_name_1 WHERE roll > 297 AND years = "7–13"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_1 (name VARCHAR, roll VARCHAR, years VARCHAR) Question: Which name has a Roll larger than 297, and Years of 7–13? [/INST] SELECT name FROM table_name_1 WHERE roll > 297 AND years = "7–13" </s>