How many games did the team lose that played 7 games and has a GA of less than 27?
CREATE TABLE "final_standing" (
  "team" text,
  "games_played" real,
  "wins" real,
  "losses" real,
  "ties" real,
  "goals_for" real,
  "goals_against" real
);
SELECT COUNT("losses") FROM "final_standing" WHERE "games_played"=7 AND "goals_against"<27;