What's the total when A Score was less than 6.9?
CREATE TABLE "qualified_competitors" (
  "position" real,
  "gymnast" text,
  "a_score" real,
  "b_score" real,
  "total" real
);
SELECT AVG("total") FROM "qualified_competitors" WHERE "a_score"<6.9;