What is the 1st leg of the UEFA Champions League Compeition in the Skonto Riga Club?
CREATE TABLE "european_record" (
  "season" text,
  "competition" text,
  "round" text,
  "club" text,
  "1st_leg" text,
  "2nd_leg" text
);
SELECT "1st_leg" FROM "european_record" WHERE "competition"='uefa champions league' AND "club"='skonto riga';