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: Quem nomeou o Juiz Edward E. Cushman?
 ###Tabelas: CREATE TABLE former_judges (former_judges_id AUTO_INCREMENT PRIMARY KEY, Judge VARCHAR, State VARCHAR, Born/Died VARCHAR, Active service VARCHAR, Chief Judge VARCHAR, Senior status VARCHAR, Appointed by VARCHAR, Reason for termination VARCHAR) CREATE TABLE lpga_tour_8 (lpga_tour_8_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Tournament VARCHAR, Winning score VARCHAR, Margin of victory VARCHAR, Runner(s)-up VARCHAR) CREATE TABLE western_conference_semi-finals (western_conference_semi-finals_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Visitor VARCHAR, Score VARCHAR, Home VARCHAR, Decision VARCHAR, Attendance INT) CREATE TABLE doubles:_5_2–3 (doubles:_5_2–3_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents VARCHAR, Score VARCHAR) CREATE TABLE cohort_teams (cohort_teams_id AUTO_INCREMENT PRIMARY KEY, Team A VARCHAR, Team C VARCHAR, Team D VARCHAR, Team E VARCHAR, Team F VARCHAR)  
SELECT Appointed by FROM former_judges WHERE Judge = edward e. cushman