CREATE TABLE table_name_14 (venue VARCHAR2, opposing_team VARCHAR2)

Venue for Hawke's bay?
SELECT venue FROM table_name_14 WHERE opposing_team = "hawke's bay"
SELECT "venue" FROM "table_name_14" WHERE "hawke's bay" = "opposing_team"