CREATE TABLE table_name_94 (date VARCHAR2, venue VARCHAR2)

When has a Venue of Adelaide Oval?
SELECT date FROM table_name_94 WHERE venue = "adelaide oval"
SELECT "date" FROM "table_name_94" WHERE "adelaide oval" = "venue"