CREATE TABLE table_name_49 (date VARCHAR2, home_team VARCHAR2)

On what date was the home team Footscray?
SELECT date FROM table_name_49 WHERE home_team = "footscray"
SELECT "date" FROM "table_name_49" WHERE "footscray" = "home_team"