Can you tell me the average Attendance that has the Scorers of steven, johnston, walters, mccoist, i.ferguson?
CREATE TABLE table_name_10 (attendance INTEGER, scorers VARCHAR)
SELECT AVG(attendance) FROM table_name_10 WHERE scorers = "steven, johnston, walters, mccoist, i.ferguson"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_10 (attendance INTEGER, scorers VARCHAR) Question: Can you tell me the average Attendance that has the Scorers of steven, johnston, walters, mccoist, i.ferguson? [/INST] SELECT AVG(attendance) FROM table_name_10 WHERE scorers = "steven, johnston, walters, mccoist, i.ferguson" </s>