CREATE TABLE table_name_9 (venue VARCHAR2, away_team VARCHAR2)

Where did Essendon play as the away team?
SELECT venue FROM table_name_9 WHERE away_team = "essendon"
SELECT "venue" FROM "table_name_9" WHERE "away_team" = "essendon"