What is the total number of appearances in the premier league when there were 10 appearances at UEFA and less than 4 at league cup?
CREATE TABLE "most_appearances" (
  "player" text,
  "position" text,
  "premier_league" real,
  "fa_cup" real,
  "league_cup" real,
  "uefa_cup" real,
  "total" real
);
SELECT COUNT("premier_league") FROM "most_appearances" WHERE "uefa_cup"=10 AND "league_cup"<4;