CREATE TABLE table_41722 ("Tie no" CLOB, "Home team" CLOB, "Score" CLOB, "Away team" CLOB, "Date" CLOB, "Attendance" CLOB)

How many ties are there where attendance is 11,997?
SELECT "Tie no" FROM table_41722 WHERE "Attendance" = '11,997'
SELECT "Tie no" FROM "table_41722" WHERE "Attendance" = '11,997'