What are the most goals listed when Jack Trehey was the player, with the listed debut year of 1902, games less than 1?
CREATE TABLE table_name_29 (goals INTEGER, games VARCHAR, debut_year VARCHAR, player VARCHAR)
SELECT MAX(goals) FROM table_name_29 WHERE debut_year = 1902 AND player = "jack trehey" AND games < 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_29 (goals INTEGER, games VARCHAR, debut_year VARCHAR, player VARCHAR) Question: What are the most goals listed when Jack Trehey was the player, with the listed debut year of 1902, games less than 1? [/INST] SELECT MAX(goals) FROM table_name_29 WHERE debut_year = 1902 AND player = "jack trehey" AND games < 1 </s>