Table: football_match_1997
Columns: home_team
home_team_score
away_team
away_team_score
ground
crowd
date
time

Question: What home team played the West Coast away team?
SQL: SELECT "home_team" FROM football_match_1997 WHERE "away_team" = 'West Coast'

Question: How many days did Hawthorn play as a home team?
SQL: SELECT COUNT("date") FROM football_match_1997 WHERE "home_team" = 'Hawthorn'

Question: What time was it when the home team's score was 10.7 (67)?
SQL: SELECT "time" FROM football_match_1997 WHERE "home_team_score" = '10.7 (67)'

Question: What time was it when the away team's score was 5.4 (34)?
SQL: SELECT "time" FROM football_match_1997 WHERE "away_team_score" = '5.4 (34)'

Question: How many days was the away team's score 11.8 (74)?
SQL: SELECT COUNT("date") FROM football_match_1997 WHERE "away_team_score" = '11.8 (74)'

Question: The away team of Richmond played on what grounds?
SQL: SELECT "ground" FROM football_match_1997 WHERE "away_team" = 'Richmond'