What is the average number of games played associated with a first game in 1997 and over 0 games drawn?
CREATE TABLE table_name_48 (played INTEGER, first_game VARCHAR, drawn VARCHAR)
SELECT AVG(played) FROM table_name_48 WHERE first_game = 1997 AND drawn > 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_48 (played INTEGER, first_game VARCHAR, drawn VARCHAR) Question: What is the average number of games played associated with a first game in 1997 and over 0 games drawn? [/INST] SELECT AVG(played) FROM table_name_48 WHERE first_game = 1997 AND drawn > 0 </s>