Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Nome da região para iwate
 ###Tabelas: CREATE TABLE main_list (main_list_id AUTO_INCREMENT PRIMARY KEY, Island VARCHAR, Group VARCHAR, Area ( ha ) VARCHAR, Population VARCHAR, Height (m) INT) CREATE TABLE composition_of_the_9th_seanad (composition_of_the_9th_seanad_id AUTO_INCREMENT PRIMARY KEY, Administrative Panel INT, Agricultural Panel INT, Cultural and Educational Panel INT, Industrial and Commercial Panel INT, Labour Panel INT, National University of Ireland INT, University of Dublin INT, Nominated by the Taoiseach INT, Total INT) CREATE TABLE launches (launches_id AUTO_INCREMENT PRIMARY KEY, Mission No. VARCHAR, Cover Name VARCHAR, Launch Date VARCHAR, NSSDC ID No. VARCHAR, Alt. Name VARCHAR, Camera VARCHAR, Notes VARCHAR) CREATE TABLE regular_season_schedule (regular_season_schedule_id AUTO_INCREMENT PRIMARY KEY, Week INT, Date VARCHAR, Opponent VARCHAR, Result VARCHAR, Attendance VARCHAR) CREATE TABLE former_special_cities_now_core_or_designated_cities (former_special_cities_now_core_or_designated_cities_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Japanese VARCHAR, Date of designation VARCHAR, Date of reclassification VARCHAR, Region VARCHAR, Prefecture VARCHAR)  
SELECT Region FROM former_special_cities_now_core_or_designated_cities WHERE Prefecture = Iwate