Which team is Team 1 with a Team 2 being Sporting CP?
CREATE TABLE "third_round" (
  "team_1" text,
  "agg" text,
  "team_2" text,
  "1st_leg" text,
  "2nd_leg" text
);
SELECT "team_1" FROM "third_round" WHERE "team_2"='sporting cp';