CREATE TABLE table_name_10 (attendance INT, scorers VARCHAR)

Can you tell me the average Attendance that has the Scorers of steven, johnston, walters, mccoist, i.ferguson?
SELECT AVG(attendance) FROM table_name_10 WHERE scorers = "steven, johnston, walters, mccoist, i.ferguson"
SELECT AVG("attendance") FROM "table_name_10" WHERE "scorers" = "steven, johnston, walters, mccoist, i.ferguson"