Who had less than 7 goals, was ranked under 7, and had more than 8 appearances?
CREATE TABLE "top_goalscorers" (
  "rank" real,
  "name" text,
  "team" text,
  "goals" real,
  "appearances" real
);
SELECT "name" FROM "top_goalscorers" WHERE "goals"<7 AND "rank"<7 AND "appearances">8;