user: Question: Who played as the away team when Coventry City was the home team?
Columns: ['Tie no', 'Home team', 'Score 1', 'Away team', 'Attendance', 'Date']
Types: ['real', 'text', 'text', 'text', 'real', 'text']
Sample row: [1.0, 'York City', '0–0', 'Manchester City', 15360.0, '21-11-1973']
SQL:

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