Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Qual é a média de empates quando os gols sofridos são menores que 56 para o Ottawa Hockey Club e os gols a favor são mais de 47?
 ###Tabelas: CREATE TABLE human_resource_development (human_resource_development_id AUTO_INCREMENT PRIMARY KEY, Region VARCHAR, Physician (GP & specialist) INT, Physician : Population Ratio VARCHAR, Health Officer INT, HO : Population Ratio VARCHAR, All Nurses INT, Nurse : Population Ratio VARCHAR, Mid-wives VARCHAR, Mid Wife: Population Ratio VARCHAR, HEW* VARCHAR) CREATE TABLE winners_by_round (winners_by_round_id AUTO_INCREMENT PRIMARY KEY, Round INT, Nominees VARCHAR, Team VARCHAR, Match VARCHAR, Ground VARCHAR) CREATE TABLE councils (councils_id AUTO_INCREMENT PRIMARY KEY, Council VARCHAR, 2003 result VARCHAR, Notional control (based on 2003 results) VARCHAR, 2007 result VARCHAR, Details VARCHAR) CREATE TABLE comparison_of_toy_group_breeds_of_major_kennel_clubs (comparison_of_toy_group_breeds_of_major_kennel_clubs_id AUTO_INCREMENT PRIMARY KEY, The Kennel Club (UK) Toy Group VARCHAR, Canadian Kennel Club Toy Dogs Group VARCHAR, American Kennel Club Toy Group VARCHAR, Australian National Kennel Council Toy Dogs Group VARCHAR, New Zealand Kennel Club Toy Group VARCHAR) CREATE TABLE final_standing (final_standing_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Games Played INT, Wins INT, Losses INT, Ties INT, Goals For INT, Goals Against INT)  
SELECT AVG Ties FROM final_standing WHERE Goals Against < 56 AND Team = ottawa hockey club AND Goals For > 47