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

Question: How many people were in the crowd when Essendon was the home team?
SQL: SELECT COUNT("crowd") FROM t_1927_vfl_match_results WHERE "home_team" = 'essendon'

Question: Which home team competed against the away team Geelong?
SQL: SELECT "home_team" FROM t_1927_vfl_match_results WHERE "away_team" = 'geelong'

Question: How many people were present in a total of every crowd at the MCG venue?
SQL: SELECT SUM("crowd") FROM t_1927_vfl_match_results WHERE "venue" = 'mcg'

Question: What was the score for the home team of Essendon?
SQL: SELECT "home_team_score" FROM t_1927_vfl_match_results WHERE "home_team" = 'essendon'

Question: What is the sum of all crowds present at the Glenferrie Oval venue?
SQL: SELECT SUM("crowd") FROM t_1927_vfl_match_results WHERE "venue" = 'glenferrie oval'