What is the sum of the appearances at the league cup for the defender who had less than 10 appearances at the UEFA cup?
CREATE TABLE "most_appearances" (
  "player" text,
  "position" text,
  "premier_league" real,
  "fa_cup" real,
  "league_cup" real,
  "uefa_cup" real,
  "total" real
);
SELECT SUM("league_cup") FROM "most_appearances" WHERE "position"='defender' AND "uefa_cup"<10;