user: Question: What is the away team with West Ham United as the home team?
Columns: ['Tie no', 'Home team', 'Score', 'Away team', 'Attendance']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['1', 'Chesterfield', '2–0', 'Bristol City', '14 January 1997']
SQL:

assistant: SELECT "Away team" FROM "Table" WHERE "Home team" = 'West Ham United';