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

Question: What is the average amount of spectators when Essendon played as the home team?
SQL: SELECT AVG("crowd") FROM t_1941_vfl_match_6 WHERE "home_team" = 'essendon'

Question: What did the away team score at MCG?
SQL: SELECT "away_team_score" FROM t_1941_vfl_match_6 WHERE "venue" = 'mcg'

Question: What did the home team score when playing against Collingwood?
SQL: SELECT "home_team_score" FROM t_1941_vfl_match_6 WHERE "away_team" = 'collingwood'

Question: Where was the game when Geelong was the away team?
SQL: SELECT "venue" FROM t_1941_vfl_match_6 WHERE "away_team" = 'geelong'

Question: What team was the away team at Arden Street Oval?
SQL: SELECT "away_team" FROM t_1941_vfl_match_6 WHERE "venue" = 'arden street oval'