What is the highest amount of goals in the position after 8, 12 losses, and played less than 30 games?
CREATE TABLE "group_ii" (
  "position" real,
  "played" real,
  "points" real,
  "wins" real,
  "draws" real,
  "losses" real,
  "goals_for" real,
  "goals_against" real,
  "goal_difference" real
);
SELECT MAX("goals_for") FROM "group_ii" WHERE "position">8 AND "losses"=12 AND "played"<30;