How many cup goals in the season with more than 5 league apps, 1 cup apps and fewer than 4 league goals?
CREATE TABLE "swindon_town_career_details" (
  "season" text,
  "team" text,
  "league_apps" real,
  "league_goals" real,
  "cup_apps" real,
  "cup_goals" real
);
SELECT SUM("cup_goals") FROM "swindon_town_career_details" WHERE "league_apps">5 AND "cup_apps"=1 AND "league_goals"<4;