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: question: Nomeie a conferência atual para 1974, 1989
 ###Tabelas: CREATE TABLE michigan_72_american_medical_school_0 (michigan_72_american_medical_school_0_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, Position VARCHAR, Starter VARCHAR, Touchdowns INT, Extra points INT, Field goals INT, Points INT) CREATE TABLE setting_the_cap (setting_the_cap_id AUTO_INCREMENT PRIMARY KEY, Authority VARCHAR, Rate or precept VARCHAR, Budget limit (£m) VARCHAR, Budget plans (£m) VARCHAR, Rate limit (p) VARCHAR, Rate change (%) VARCHAR, Desired rate (p) VARCHAR, Desired rate change (%) VARCHAR) CREATE TABLE former_conference_members (former_conference_members_id AUTO_INCREMENT PRIMARY KEY, Institution VARCHAR, Location VARCHAR, Founded INT, Type VARCHAR, Enrollment INT, Nickname VARCHAR, Joined VARCHAR, Left VARCHAR, Current Conference VARCHAR) CREATE TABLE arab_violence (arab_violence_id AUTO_INCREMENT PRIMARY KEY, Conflicts prior to Israel's independence VARCHAR, Military deaths VARCHAR, Civilian deaths VARCHAR, Total deaths VARCHAR, Military and/or Civilian wounded VARCHAR, Total casualties VARCHAR) CREATE TABLE complete_formula_one_world_championship_results (complete_formula_one_world_championship_results_id AUTO_INCREMENT PRIMARY KEY, Year INT, Entrant VARCHAR, Chassis VARCHAR, Engine VARCHAR, Points INT)  
SELECT Current Conference FROM former_conference_members WHERE Left = 1974, 1989