Table: t_1947_vfl_match_6
Columns: home_team
home_team_score
away_team
away_team_score
venue
crowd
date

Question: In the game where Collingwood is the home team what is the score of the away team?
SQL: SELECT "away_team_score" FROM t_1947_vfl_match_6 WHERE "home_team" = 'collingwood'

Question: What is the home teamscore for Richmond?
SQL: SELECT "home_team_score" FROM t_1947_vfl_match_6 WHERE "home_team" = 'richmond'