Table: afl_game_stats
Columns: home_team
home_team_score
away_team
away_team_score
ground
crowd
date
report

Question: What day was the ground subiaco?
SQL: SELECT "date" FROM afl_game_stats WHERE "ground" = 'subiaco'

Question: Which home team had a score of 11.11 (77)?
SQL: SELECT "home_team" FROM afl_game_stats WHERE "home_team_score" = '11.11 (77)'

Question: What's the average crowd when the away team score was 14.14 (98)?
SQL: SELECT AVG("crowd") FROM afl_game_stats WHERE "away_team_score" = '14.14 (98)'

Question: Which away team score had a home team score of 15.8 (98)?
SQL: SELECT "away_team_score" FROM afl_game_stats WHERE "home_team_score" = '15.8 (98)'

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

Question: What was the crowd size for the Home team of melbourne?
SQL: SELECT COUNT("crowd") FROM afl_game_stats WHERE "home_team" = 'melbourne'