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

Question: When the Away team had a score of 11.16 (82), what is the average Crowd?
SQL: SELECT AVG("crowd") FROM footscray_melbourne_game WHERE "away_team_score" = '11.16 (82)'

Question: Which Away team has a score of 6.17 (53)?
SQL: SELECT "away_team" FROM footscray_melbourne_game WHERE "away_team_score" = '6.17 (53)'

Question: Which Away team has Carlton for it's Home team?
SQL: SELECT "away_team" FROM footscray_melbourne_game WHERE "home_team" = 'carlton'

Question: Which Venue has Footscray as it's Home team?
SQL: SELECT "venue" FROM footscray_melbourne_game WHERE "home_team" = 'footscray'