CREATE TABLE table_name_43 (tie_no VARCHAR, attendance VARCHAR)

How many ties are there where attendance is 11,997?
SELECT tie_no FROM table_name_43 WHERE attendance = "11,997"
SELECT "tie_no" FROM "table_name_43" WHERE "11,997" = "attendance"