user: Question: What is the average home team score for Footscray?
Columns: ['Home team', 'Home team score', 'Away team', 'Away team score', 'Venue', 'Crowd', 'Date']
Types: ['text', 'text', 'text', 'text', 'text', 'real', 'text']
Sample row: ['Melbourne', '18.14 (122)', 'Richmond', '14.15 (99)', 'MCG', 20044.0, '4 May 1940']
SQL:

assistant: SELECT AVG("Home team score") FROM "Table" WHERE "Home team" = 'Footscray';