CREATE TABLE table_name_37 (attendance VARCHAR2, date VARCHAR2)

How many people in total attended the game on 1 november 1997?
SELECT COUNT(attendance) FROM table_name_37 WHERE date = "1 november 1997"
SELECT COUNT("attendance") FROM "table_name_37" WHERE "1 november 1997" = "date"