What was the sum of ranks of those called Fernando Cavenaghi who appeared less than 7.
CREATE TABLE "top_goalscorers" (
  "rank" real,
  "name" text,
  "team" text,
  "goals" real,
  "appearances" real
);
SELECT SUM("rank") FROM "top_goalscorers" WHERE "name"='fernando cavenaghi' AND "appearances"<7;