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

Question: Who is the away team that played home team Hawthorn?
SQL: SELECT "away_team" FROM t_1974_vfl_match_3 WHERE "home_team" = 'hawthorn'

Question: What is the name of the home team that played away team Footscray?
SQL: SELECT "home_team" FROM t_1974_vfl_match_3 WHERE "away_team" = 'footscray'

Question: Who is the home team that played at venue MCG?
SQL: SELECT "home_team" FROM t_1974_vfl_match_3 WHERE "venue" = 'mcg'