Which away has apoel as the club?
CREATE TABLE "european_record" (
  "season" text,
  "competition" text,
  "round" text,
  "club" text,
  "home" text,
  "away" text
);
SELECT "away" FROM "european_record" WHERE "club"='apoel';