CREATE TABLE table_name_40 (away_team VARCHAR, home_team VARCHAR)

What was Essendon's opponents away score?
SELECT away_team AS score FROM table_name_40 WHERE home_team = "essendon"
SELECT "away_team" AS "score" FROM "table_name_40" WHERE "essendon" = "home_team"