user: Question: Who was the home team when the away team was 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: ['North Melbourne', '9.10 (64)', 'Richmond', '10.7 (67)', 'Arden Street Oval', 10000.0, '2 August 1941']
SQL:

assistant: SELECT "Home team" FROM "Table" WHERE "Away team" = 'Footscray';