user: ### NOW ANSWER:
Question: Who played against the away team Hereford United?
Columns: ['Tie no', 'Home team', 'Score', 'Away team', 'Date']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['1', 'Bristol City', '0–1', 'Torquay United', '5 December 1987']
SQL:

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