user: ### NOW ANSWER:
Question: Playing against Chelmsford City on 15 November 1986, who was the home team?
Columns: ['Tie no', 'Home team', 'Score', 'Away team', 'Date']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['1', 'Chester City', '1–1', 'Rotherham United', '15 November 1986']
SQL:

assistant: SELECT "Home team" FROM "Table" WHERE "Date" = '15 November 1986' AND "Away team" = 'Chelmsford City';