CREATE TABLE table_29 ("Member" CLOB, "Electorate" CLOB, "Province" CLOB, "MPs term" CLOB, "Election date" CLOB)

Which province is bay of islands in
SELECT "Province" FROM table_29 WHERE "Electorate" = 'Bay of Islands'
SELECT "Province" FROM "table_29" WHERE "Electorate" = 'Bay of Islands'