Which Debut year has a Player of noel carroll, and Games smaller than 12?
CREATE TABLE table_name_95 (debut_year INTEGER, player VARCHAR, games VARCHAR)
SELECT MAX(debut_year) FROM table_name_95 WHERE player = "noel carroll" AND games < 12
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_95 (debut_year INTEGER, player VARCHAR, games VARCHAR) Question: Which Debut year has a Player of noel carroll, and Games smaller than 12? [/INST] SELECT MAX(debut_year) FROM table_name_95 WHERE player = "noel carroll" AND games < 12 </s>