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

Question: What is essendon's home team score?
SQL: SELECT "home_team_score" FROM t_1949_vfl_match_4 WHERE "home_team" = 'essendon'

Question: What is the average crowd when footscray is at home?
SQL: SELECT AVG("crowd") FROM t_1949_vfl_match_4 WHERE "home_team" = 'footscray'

Question: What is the listed crowd at windy hill?
SQL: SELECT "crowd" FROM t_1949_vfl_match_4 WHERE "venue" = 'windy hill'

Question: What is the away team's score at punt road oval?
SQL: SELECT "away_team" FROM t_1949_vfl_match_4 WHERE "venue" = 'punt road oval'