CREATE TABLE table_name_23 (home_team VARCHAR2)

What did Footscray score at the home game?
SELECT home_team AS score FROM table_name_23 WHERE home_team = "footscray"
SELECT "home_team" AS "score" FROM "table_name_23" WHERE "footscray" = "home_team"