Name the most goals with losses less than 15 and position more than 8 with points of 42+4
CREATE TABLE "final_table" (
  "position" real,
  "club" text,
  "played" real,
  "points" text,
  "wins" real,
  "draws" real,
  "losses" real,
  "goals_for" real,
  "goals_against" real,
  "goal_difference" real
);
SELECT MAX("goals_for") FROM "final_table" WHERE "losses"<15 AND "position">8 AND "points"='42+4';