CREATE TABLE table_78522 ("Team" CLOB, "Games Played" FLOAT, "Wins" FLOAT, "Losses" FLOAT, "Ties" FLOAT, "Goals For" FLOAT, "Goals Against" FLOAT)

For teams with fewer than 5 wins, goals against over 37, and fewer than 8 games played, what is the average number of ties?
SELECT AVG("Ties") FROM table_78522 WHERE "Wins" < '5' AND "Goals Against" > '37' AND "Games Played" < '8'
SELECT AVG("Ties") FROM "table_78522" WHERE "Games Played" < '8' AND "Goals Against" > '37' AND "Wins" < '5'