what is the total scored for the 8th position and a score more than 6.6
CREATE TABLE "qualified_competitors" (
  "position" text,
  "gymnast" text,
  "a_score" real,
  "b_score" real,
  "total" real
);
SELECT MAX("total") FROM "qualified_competitors" WHERE "position"='8th' AND "a_score">6.6;