CREATE TABLE table_name_65 (home_team VARCHAR2)

What did the home team footscray score?
SELECT home_team AS score FROM table_name_65 WHERE home_team = "footscray"
SELECT "home_team" AS "score" FROM "table_name_65" WHERE "footscray" = "home_team"