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: Me diga a província de 1941-1946.
 ###Tabelas: CREATE TABLE nielsen_ratings (nielsen_ratings_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Timeslot Times listed are Eastern time VARCHAR, Season premiere VARCHAR, Season finale VARCHAR, TV season VARCHAR, Ranking INT, Viewers (in millions of households) VARCHAR) CREATE TABLE  (_id AUTO_INCREMENT PRIMARY KEY, Camp VARCHAR, Place VARCHAR, Province VARCHAR, Location VARCHAR, Period VARCHAR) CREATE TABLE top_10_attendances (top_10_attendances_id AUTO_INCREMENT PRIMARY KEY, Attendance INT, Round VARCHAR, Date VARCHAR, Home VARCHAR, Score VARCHAR, Away VARCHAR, Venue VARCHAR, Weekday VARCHAR, Time of Day VARCHAR) CREATE TABLE largest_employers (largest_employers_id AUTO_INCREMENT PRIMARY KEY, Rank (2012) INT, Rank (2010) INT, Employer VARCHAR, Industry VARCHAR, 2012 Employees (Total) INT, 2010 Employees (Total) INT, 2007 Employees (Total) VARCHAR, Head office VARCHAR) CREATE TABLE production_and_source (production_and_source_id AUTO_INCREMENT PRIMARY KEY, Country VARCHAR, Electricity production (Kw/h, billion) INT, % Coal INT, % Natural gas INT, % Oil INT, % Hydropower INT, % Other renewable INT, % Nuclear power INT)  
SELECT Province FROM  WHERE Period = 1941-1946