How many goals against were scored when the goals for is less than 48 with 0 ties?
CREATE TABLE "final_standing" (
  "team" text,
  "games_played" real,
  "wins" real,
  "losses" real,
  "ties" real,
  "goals_for" real,
  "goals_against" real
);
SELECT COUNT("goals_against") FROM "final_standing" WHERE "goals_for"<48 AND "ties"<0;