Table: new_zealand_provinces
Columns: province
formed_date
formed_from
dissolution_date
reason

Question: What province was New Plymouth formed from?
SQL: SELECT "formed_from" FROM new_zealand_provinces WHERE "province" = 'New Plymouth'

Question: Why was Otago formed?
SQL: SELECT "reason" FROM new_zealand_provinces WHERE "province" = 'Otago'

Question: What provinces were formed from New Munster?
SQL: SELECT "province" FROM new_zealand_provinces WHERE "formed_from" = 'New Munster'

Question: How many provinces are named Wellington?
SQL: SELECT COUNT("formed_date") FROM new_zealand_provinces WHERE "province" = 'Wellington'

Question: What provinces were formed from New Munster?
SQL: SELECT "province" FROM new_zealand_provinces WHERE "formed_from" = 'New Munster'