user: ### NOW ANSWER:
Question: What is the average crowd when Footscray is at home?
Columns: ['Home team', 'Home team score', 'Away team', 'Away team score', 'Venue', 'Crowd', 'Date']
Types: ['text', 'text', 'text', 'text', 'text', 'real', 'text']
Sample row: ['Footscray', '11.8 (74)', 'Melbourne', '10.12 (72)', 'Western Oval', 13000.0, '23 July 1949']
SQL:

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