What is the average number of goals of the player with 234 apps and a rank above 8?
CREATE TABLE "all_time_top_scorers" (
  "rank" real,
  "player" text,
  "goals" real,
  "apps" real,
  "avg_game" real
);
SELECT AVG("goals") FROM "all_time_top_scorers" WHERE "apps"=234 AND "rank"<8;