How many appearances were made by people that had 5 goals and less than 7 rank?
CREATE TABLE "top_goalscorers" (
  "rank" real,
  "name" text,
  "team" text,
  "goals" real,
  "appearances" real
);
SELECT COUNT("appearances") FROM "top_goalscorers" WHERE "goals"=5 AND "rank"<7;