What was the average of wins with manager George Scherger smaller than 3 and losses smaller than 1?
CREATE TABLE "managers" (
  "manager" text,
  "years" text,
  "games" real,
  "wins" real,
  "losses" real
);
SELECT AVG("wins") FROM "managers" WHERE "games"<3 AND "manager"='george scherger' AND "losses"<1;