What is the average Games for 1965–1981, and a Ranking larger than 4?
CREATE TABLE "all_time_most_appearances" (
  "ranking" real,
  "nationality" text,
  "name" text,
  "games" real,
  "years" text
);
SELECT AVG("games") FROM "all_time_most_appearances" WHERE "years"='1965–1981' AND "ranking">4;