Which attendance has 9 as the tie no.?
CREATE TABLE "second_round" (
  "tie_no" real,
  "home_team" text,
  "score" text,
  "away_team" text,
  "report" text,
  "attendance" real
);
SELECT "attendance" FROM "second_round" WHERE "tie_no"=9;