What are the average goals for with a drawn higher than 7 and goals against less than 86, as well as more than 11 losses and more than 42 games played?
CREATE TABLE "final_table" (
  "position" real,
  "team" text,
  "played" real,
  "drawn" real,
  "lost" real,
  "goals_for" real,
  "goals_against" real,
  "goal_difference" text,
  "points_1" real
);
SELECT AVG("goals_for") FROM "final_table" WHERE "drawn">7 AND "goals_against"<86 AND "lost">11 AND "played">42;