CREATE TABLE table_name_47 (away_team VARCHAR2, home_team VARCHAR2)

What did the away team score when they were playing collingwood?
SELECT away_team AS score FROM table_name_47 WHERE home_team = "collingwood"
SELECT "away_team" AS "score" FROM "table_name_47" WHERE "collingwood" = "home_team"