user: ### NOW ANSWER:
Question: On what day was the attendance that had a Tie value of 40?
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 "Attendance" FROM "Table" WHERE "Tie no" = '40';