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

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

Question: Which date has a game where the away team had a score of 10.8 (68)?
SQL: SELECT "date" FROM t_1947_vfl_football_games WHERE "away_team_score" = '10.8 (68)'

Question: What is the size of the biggest crowd for a game where Fitzroy was the away team?
SQL: SELECT MAX("crowd") FROM t_1947_vfl_football_games WHERE "away_team" = 'fitzroy'

Question: Which team had an away score of 15.14 (104)?
SQL: SELECT "home_team" FROM t_1947_vfl_football_games WHERE "away_team_score" = '15.14 (104)'

Question: On which date did Footscray play an away game?
SQL: SELECT "date" FROM t_1947_vfl_football_games WHERE "away_team" = 'footscray'