CREATE TABLE table_name_72 (date VARCHAR2, opposing_team VARCHAR2)

When has an Opposing Team of mid-districts?
SELECT date FROM table_name_72 WHERE opposing_team = "mid-districts"
SELECT "date" FROM "table_name_72" WHERE "mid-districts" = "opposing_team"