What is the total number of losses for less than 48 games, and less than 7 draws?
CREATE TABLE "all_time_table" (
  "league" text,
  "number_of_seasons" real,
  "total_games" real,
  "draw" real,
  "loss" real
);
SELECT COUNT("loss") FROM "all_time_table" WHERE "total_games"<48 AND "draw"<7;