What are the total losses with 2 matches, 2 against, 0% of draws and less than 1 wins?
CREATE TABLE "by_clubs" (
  "team" text,
  "matches" real,
  "wins" real,
  "wins_pct" text,
  "draws" real,
  "draws_pct" text,
  "losses" real,
  "losses_pct" text,
  "against" real,
  "for_against_ratio" text
);
SELECT SUM("losses") FROM "by_clubs" WHERE "matches"=2 AND "against"=2 AND "draws_pct"='0%' AND "wins"<1;