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