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"