CREATE TABLE table_name_92 (crowd INT, home_team VARCHAR)

What is the average crowd attendance for Collingwood?
SELECT AVG(crowd) FROM table_name_92 WHERE home_team = "collingwood"
SELECT AVG("crowd") FROM "table_name_92" WHERE "collingwood" = "home_team"