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: Quais foram os anos da Premiership que ocorreram na Competição de 1983-1992?
 ###Tabelas: CREATE TABLE tier_i_financial_institutions (tier_i_financial_institutions_id AUTO_INCREMENT PRIMARY KEY, Rank VARCHAR, Bank VARCHAR, Assets (USD) Millions INT, Market Share VARCHAR, Number of Branches INT) CREATE TABLE by_population (by_population_id AUTO_INCREMENT PRIMARY KEY, Province VARCHAR, Population INT, Region VARCHAR, Name of City VARCHAR, Districts INT) CREATE TABLE tertiary_institutions (tertiary_institutions_id AUTO_INCREMENT PRIMARY KEY, Institution VARCHAR, Location VARCHAR, Enrollment VARCHAR, Athletic nickname VARCHAR, School Colors VARCHAR, Founded INT) CREATE TABLE 2008_season_players (2008_season_players_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, Squad no INT, Appearances INT, Tries INT, Goals INT, F Goals INT, Points INT, Contract ends INT) CREATE TABLE previous_clubs (previous_clubs_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, Nickname VARCHAR, Years in Competition VARCHAR, No. of Premierships INT, Premiership Years VARCHAR)  
SELECT Premiership Years FROM previous_clubs WHERE Years in Competition = 1983-1992