CREATE TABLE table_name_47 (venue VARCHAR2, home_team VARCHAR2)

What venue features collingwood as the home side?
SELECT venue FROM table_name_47 WHERE home_team = "collingwood"
SELECT "venue" FROM "table_name_47" WHERE "collingwood" = "home_team"