How many draws with 1 loss?
CREATE TABLE "captains" (
  "name" text,
  "first_captaincy" text,
  "games_as_captain" real,
  "wins" real,
  "draws" real,
  "losses" real
);
SELECT SUM("draws") FROM "captains" WHERE "losses"=1;