user: ### NOW ANSWER:
Question: For teams with fewer than 5 wins, goals against over 37, and fewer than 8 games played, what is the average number of ties?
Columns: ['Team', 'Games Played', 'Wins', 'Losses', 'Ties', 'Goals For', 'Goals Against']
Types: ['text', 'real', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Montreal Victorias', 8.0, 7.0, 1.0, 0.0, 48.0, 26.0]
SQL:

assistant: SELECT AVG("Ties") FROM "Table" WHERE "Wins" < 5.0 AND "Goals Against" > 37.0 AND "Games Played" < 8.0;