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 pontuação média do time da casa para Footscray?
 ###Tabelas: CREATE TABLE round_four (round_four_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Time VARCHAR, Home VARCHAR, Away VARCHAR, Score VARCHAR, Ground VARCHAR) CREATE TABLE lpga_tour_wins_7 (lpga_tour_wins_7_id AUTO_INCREMENT PRIMARY KEY, No. INT, Date VARCHAR, Tournament VARCHAR, Winning score VARCHAR, To par VARCHAR, Margin of victory VARCHAR, Runner(s)-up VARCHAR) CREATE TABLE round_2 (round_2_id AUTO_INCREMENT PRIMARY KEY, Home team VARCHAR, Home team score VARCHAR, Away team VARCHAR, Away team score VARCHAR, Venue VARCHAR, Crowd INT, Date VARCHAR) CREATE TABLE head_coaches_and_all-time_results (head_coaches_and_all-time_results_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Years VARCHAR, Seasons INT, Lost INT, Pct. INT) CREATE TABLE principal_roles_and_cast_members (principal_roles_and_cast_members_id AUTO_INCREMENT PRIMARY KEY, Character VARCHAR, Original Manchester Performer VARCHAR, Original West End Performer VARCHAR, Original Broadway Performer VARCHAR, Original UK Tour Performer VARCHAR, Original Non-Equity US Tour Performer VARCHAR, Original Italian Tour Performer VARCHAR, Original South Korean Performer VARCHAR)  
SELECT Home team score FROM round_2 WHERE Home team = footscray