What is the attendance when Cork City is the opponent?
CREATE TABLE "pre_season_and_friendlies" (
  "date" text,
  "opponents" text,
  "h_a" text,
  "result_f_a" text,
  "attendance" real
);
SELECT AVG("attendance") FROM "pre_season_and_friendlies" WHERE "opponents"='cork city';