How many goals for occurred when the goals against was less than 56 and games played was larger than 7 with less than 6 wins?
CREATE TABLE "final_standing" (
  "team" text,
  "games_played" real,
  "wins" real,
  "losses" real,
  "ties" real,
  "goals_for" real,
  "goals_against" real
);
SELECT COUNT("goals_for") FROM "final_standing" WHERE "goals_against"<56 AND "games_played">7 AND "wins"<6;