CREATE TABLE table_45687 ("Opposing Team" CLOB, "Against" FLOAT, "Date" CLOB, "Venue" CLOB, "Status" CLOB)

Venue for Hawke's bay?
SELECT "Venue" FROM table_45687 WHERE "Opposing Team" = 'hawke''s bay'
SELECT "Venue" FROM "table_45687" WHERE "Opposing Team" = 'hawke''s bay'