What is the aveage Egypt Cup value for players with 0 CAF Champions League goals, 6 Egyptian Premier League goals, and totals under 6?
CREATE TABLE "top_scorers" (
  "name" text,
  "egyptian_premier_league" real,
  "egypt_cup" real,
  "caf_champions_league" real,
  "total" real
);
SELECT AVG("egypt_cup") FROM "top_scorers" WHERE "caf_champions_league"=0 AND "egyptian_premier_league"=6 AND "total"<6;