Who has the first leg that has a round in the semi-final?
CREATE TABLE "club_brugge" (
  "round" text,
  "opposition" text,
  "first_leg" text,
  "second_leg" text,
  "aggregate_score" text
);
SELECT "first_leg" FROM "club_brugge" WHERE "round"='semi-final';