CREATE TABLE table_name_32 (date VARCHAR2, competition VARCHAR2, venue VARCHAR2)

On what date was a friendly match held at Auckland?
SELECT date FROM table_name_32 WHERE competition = "friendly match" AND venue = "auckland"
SELECT "date" FROM "table_name_32" WHERE "auckland" = "venue" AND "competition" = "friendly match"