Table: manu_97_98_season
Columns: date
opponents
result_f_a
attendance
league_position

Question: How many people in total attended the game on 1 november 1997?
SQL: SELECT COUNT("attendance") FROM manu_97_98_season WHERE "date" = '1 november 1997'