Where was the venue that Linfield was the opponent?
CREATE TABLE "friendlies" (
  "date" text,
  "opponent" text,
  "venue" text,
  "result" text,
  "attendance" real
);
SELECT "venue" FROM "friendlies" WHERE "opponent"='linfield';