user: ### NOW ANSWER:
Question: How many ties are there where attendance is 11,997?
Columns: ['Tie no', 'Home team', 'Score', 'Away team', 'Date', 'Attendance']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['1', 'Blackpool', '1 – 2', 'Crystal Palace', '4 January 2003', '9,062']
SQL:

assistant: SELECT "Tie no" FROM "Table" WHERE "Attendance" = '11,997';