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 o juiz-chefe que tem motivo para aposentadoria compulsória.
 ###Tabelas: CREATE TABLE season_1:_2007–2009 (season_1:_2007–2009_id AUTO_INCREMENT PRIMARY KEY, Prod. No. VARCHAR, Title VARCHAR, Written by VARCHAR, Directed by VARCHAR, Original airdate VARCHAR) CREATE TABLE freedom_conference (freedom_conference_id AUTO_INCREMENT PRIMARY KEY, Institution VARCHAR, Location VARCHAR, Nickname VARCHAR, Founded INT, Type VARCHAR, Enrollment INT, Joined MAC INT) CREATE TABLE performance_against_each_opponent (performance_against_each_opponent_id AUTO_INCREMENT PRIMARY KEY, Matches INT, Innings INT, Not out INT, Runs INT, High Score INT, Average INT) CREATE TABLE 75_million_to_79_million_records (75_million_to_79_million_records_id AUTO_INCREMENT PRIMARY KEY, Artist VARCHAR, Country of origin VARCHAR, Period active VARCHAR, Release-year of first charted record INT, Genre VARCHAR, Claimed sales VARCHAR) CREATE TABLE former_judges (former_judges_id AUTO_INCREMENT PRIMARY KEY, State VARCHAR, Born/Died VARCHAR, Active service VARCHAR, Chief Judge VARCHAR, Senior status VARCHAR, Appointed by VARCHAR, Reason for termination VARCHAR)  
SELECT Chief Judge FROM former_judges WHERE Reason for termination = retirement