user: ### NOW ANSWER:
Question: 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?
Columns: ['Coach', 'Years', 'Wins', 'Losses', 'Ties']
Types: ['text', 'text', 'real', 'real', 'real']
Sample row: ['Murray Armstrong *', '1956 to 1977', 463.0, 215.0, 31.0]
SQL:

assistant: SELECT AVG("Wins") FROM "Table" WHERE "Losses" < 174.0 AND "Years" = '1951 to 1956' AND "Ties" < 6.0;