CREATE TABLE table_name_70 (wins INT, ties VARCHAR, losses VARCHAR, years VARCHAR)

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?
SELECT AVG(wins) FROM table_name_70 WHERE losses < 174 AND years = "1951 to 1956" AND ties < 6
SELECT AVG("wins") FROM "table_name_70" WHERE "1951 to 1956" = "years" AND "losses" < 174 AND "ties" < 6