CREATE TABLE table_name_37 (attendance VARCHAR(255), date VARCHAR(255))
How many people in total attended the game on 1 november 1997?
    
SQL: SELECT COUNT(attendance) FROM table_name_37 WHERE date = "1 november 1997"