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

Question: When the Away team is footscray, what is the Home team playing?
SQL: SELECT "home_team" FROM t_1977_vfl_match_4 WHERE "away_team" = 'footscray'

Question: When the Home team scores 14.16 (100), what is the sum of the Crowds?
SQL: SELECT SUM("crowd") FROM t_1977_vfl_match_4 WHERE "home_team_score" = '14.16 (100)'

Question: What's the average number of people in the Crowd that attend essendon games as the Home team?
SQL: SELECT AVG("crowd") FROM t_1977_vfl_match_4 WHERE "home_team" = 'essendon'

Question: Which Away team plays at the Venue vfl park?
SQL: SELECT "away_team" FROM t_1977_vfl_match_4 WHERE "venue" = 'vfl park'