what is the average league cup goals when the league cup apps is 4, league goals is less than 4, fa cup apps is 1 and total apps is 35?
CREATE TABLE "appearances_and_goals" (
  "name" text,
  "position" text,
  "league_apps" text,
  "league_goals" real,
  "fa_cup_apps" text,
  "fa_cup_goals" real,
  "league_cup_apps" real,
  "league_cup_goals" real,
  "total_apps" text,
  "total_goals" real
);
SELECT AVG("league_cup_goals") FROM "appearances_and_goals" WHERE "league_cup_apps"=4 AND "league_goals"<4 AND "fa_cup_apps"='1' AND "total_apps"='35';