What is the sum of rank with years  1996–2012 and apps greater than 340?
CREATE TABLE "goalscoring" (
  "rank" real,
  "name" text,
  "years" text,
  "goals" real,
  "apps" real
);
SELECT SUM("rank") FROM "goalscoring" WHERE "years"='1996–2012' AND "apps">340;