user: ### NOW ANSWER:
Question: Who was the home team for the away game that Canvey Island played?
Columns: ['Tie no', 'Home team', 'Score', 'Away team', 'Attendance']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['1', 'Blackpool', '2–1', 'Chester City', '11 November 1995']
SQL:

assistant: SELECT "Home team" FROM "Table" WHERE "Away team" = 'Canvey Island';