Which position had a goal difference of less than 27, lost more than 13 games, scored less than 42 goals and drew 6 games?
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("played") FROM "final_table" WHERE "goal_difference"<27 AND "losses">13 AND "goals_for"<42 AND "draws"=6;