What round had the opponent Lyon?
CREATE TABLE "club_brugge" (
  "round" text,
  "opposition" text,
  "first_leg" text,
  "second_leg" text,
  "aggregate_score" text
);
SELECT "round" FROM "club_brugge" WHERE "opposition"='lyon';