How many were in Attendance on October 8?
CREATE TABLE "houston_astros_vs_new_york_mets" (
  "game" real,
  "date" text,
  "score" text,
  "location" text,
  "time" text,
  "attendance" real
);
SELECT COUNT("attendance") FROM "houston_astros_vs_new_york_mets" WHERE "date"='october 8';