Table: football_match_stats
Columns: home_team
home_team_score
away_team
away_team_score
ground
crowd
date

Question: What was the home team score when Brisbane lions was the home team?
SQL: SELECT "home_team_score" FROM football_match_stats WHERE "home_team" = 'Brisbane Lions'

Question: When was the game played on Manuka Oval?
SQL: SELECT "date" FROM football_match_stats WHERE "ground" = 'Manuka Oval'

Question: What was the score for the home team when the away team was Sydney?
SQL: SELECT "home_team_score" FROM football_match_stats WHERE "away_team" = 'Sydney'