CREATE TABLE table_name_40 (game_site VARCHAR, date VARCHAR)

Name the game site for october 4, 1992
SELECT game_site FROM table_name_40 WHERE date = "october 4, 1992"
SELECT "game_site" FROM "table_name_40" WHERE "date" = "october 4, 1992"