user: ### NOW ANSWER:
Question: What team was the away team when the tie no is 40?
Columns: ['Tie no', 'Home team', 'Score', 'Away team', 'Date']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['1', 'Ashford Town (Kent)', '1–3', 'Walsall', '27 November 1974']
SQL:

assistant: SELECT "Away team" FROM "Table" WHERE "Tie no" = '40';