What is the average Games, when Player is Robert Hock, and when Goals is less than 24?
CREATE TABLE table_name_19 (games INTEGER, player VARCHAR, goals VARCHAR)
SELECT AVG(games) FROM table_name_19 WHERE player = "robert hock" AND goals < 24
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_19 (games INTEGER, player VARCHAR, goals VARCHAR) Question: What is the average Games, when Player is Robert Hock, and when Goals is less than 24? [/INST] SELECT AVG(games) FROM table_name_19 WHERE player = "robert hock" AND goals < 24 </s>