user: Question: What is the average number of ties when goals against is less than 56 for ottawa hockey club and the goals for is more than 47?
Columns: ['Team', 'Games Played', 'Wins', 'Losses', 'Ties', 'Goals For', 'Goals Against']
Types: ['text', 'real', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Ottawa Hockey Club', 8.0, 6.0, 2.0, 0.0, 47.0, 26.0]
SQL:

assistant: SELECT AVG("Ties") FROM "Table" WHERE "Goals Against" < 56.0 AND "Team" = 'ottawa hockey club' AND "Goals For" > 47.0;