CREATE TABLE table_name_42 (venue VARCHAR, away_team VARCHAR)

What venue did the away team Collingwood play at?
SELECT venue FROM table_name_42 WHERE away_team = "collingwood"
SELECT "venue" FROM "table_name_42" WHERE "away_team" = "collingwood"