What is the average number of wins for the person who coached from 1951 to 1956 and had less than 174 losses and less than 6 ties?
CREATE TABLE "coaching_records" (
  "coach" text,
  "years" text,
  "wins" real,
  "losses" real,
  "ties" real
);
SELECT AVG("wins") FROM "coaching_records" WHERE "losses"<174 AND "years"='1951 to 1956' AND "ties"<6;