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

Question: If collingwood is playing away, who played as the home team?
SQL: SELECT "home_team" FROM vfl_1978_game WHERE "away_team" = 'collingwood'

Question: What was the away teams score when they played at kardinia park?
SQL: SELECT "away_team_score" FROM vfl_1978_game WHERE "venue" = 'kardinia park'

Question: What's the highest turnout when carlton was playing as the away team?
SQL: SELECT MAX("crowd") FROM vfl_1978_game WHERE "away_team" = 'carlton'

Question: Which home team scored 15.11 (101)?
SQL: SELECT "home_team" FROM vfl_1978_game WHERE "home_team_score" = '15.11 (101)'

Question: Which away team scored 23.11 (149)?
SQL: SELECT "away_team" FROM vfl_1978_game WHERE "away_team_score" = '23.11 (149)'