How many Ties have Wins smaller than 1, and Games of 6, and Losses of 6, and a Season larger than 1941?
CREATE TABLE "cfl_teams_with_one_or_no_wins_in_a_seaso" (
  "season" real,
  "team" text,
  "games" real,
  "wins" real,
  "losses" real,
  "ties" real
);
SELECT COUNT("ties") FROM "cfl_teams_with_one_or_no_wins_in_a_seaso" WHERE "wins"<1 AND "games"=6 AND "losses"=6 AND "season">1941;