CREATE TABLE table_name_49 (away_team VARCHAR, home_team VARCHAR)

When the Home team of collingwood played, what was the opposing Away team score?
SELECT away_team AS score FROM table_name_49 WHERE home_team = "collingwood"
SELECT "away_team" AS "score" FROM "table_name_49" WHERE "collingwood" = "home_team"