user: Question: Who was the away team when the home team was Norwich City?
Columns: ['Tie no', 'Home team', 'Score', 'Away team', 'Date']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['1', 'Bournemouth', '1–1', 'Manchester United', '18 February 1989']
SQL:

assistant: SELECT "Away team" FROM "Table" WHERE "Home team" = 'Norwich City';