CREATE TABLE table_name_9 (away_team VARCHAR, home_team VARCHAR)

What was home team Essendon's opponents score?
SELECT away_team AS score FROM table_name_9 WHERE home_team = "essendon"
SELECT "away_team" AS "score" FROM "table_name_9" WHERE "essendon" = "home_team"