Table schema:
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
SQL: SELECT away_team FROM table_name_74 WHERE home_team = "richmond"