what is the sum of games played when the losses is less than 7, the wins is 6 and the goals for is more than 76?
CREATE TABLE "final_standing" (
  "team" text,
  "games_played" real,
  "wins" real,
  "losses" real,
  "ties" real,
  "goals_for" real,
  "goals_against" real
);
SELECT SUM("games_played") FROM "final_standing" WHERE "losses"<7 AND "wins"=6 AND "goals_for">76;