CREATE TABLE table_name_95 (debut_year INT, player VARCHAR, games VARCHAR)

Which Debut year has a Player of noel carroll, and Games smaller than 12?
SELECT MAX(debut_year) FROM table_name_95 WHERE player = "noel carroll" AND games < 12
SELECT MAX("debut_year") FROM "table_name_95" WHERE "games" < 12 AND "noel carroll" = "player"