What is the average Goals, when Club is Iserlohn Roosters, and when Games is less than 56?
CREATE TABLE table_name_45 (goals INTEGER, club VARCHAR, games VARCHAR)
SELECT AVG(goals) FROM table_name_45 WHERE club = "iserlohn roosters" AND games < 56
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_45 (goals INTEGER, club VARCHAR, games VARCHAR) Question: What is the average Goals, when Club is Iserlohn Roosters, and when Games is less than 56? [/INST] SELECT AVG(goals) FROM table_name_45 WHERE club = "iserlohn roosters" AND games < 56 </s>