I want to see the away team the has a home team of richmond
CREATE TABLE table_name_74 (away_team VARCHAR, home_team VARCHAR)
SELECT away_team FROM table_name_74 WHERE home_team = "richmond"
### Context: CREATE TABLE table_name_74 (away_team VARCHAR, home_team VARCHAR) ### Question: I want to see the away team the has a home team of richmond ### Answer: SELECT away_team FROM table_name_74 WHERE home_team = "richmond"