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: Nomeie o candidato primeiro eleito em 1942.
 ###Tabelas: CREATE TABLE moves_played_compared_with_computer_choices (moves_played_compared_with_computer_choices_id AUTO_INCREMENT PRIMARY KEY, Position INT, best year VARCHAR, best 2-year period VARCHAR, best 3-year period VARCHAR, best 5-year period VARCHAR, best 10-year period VARCHAR, best 15-year period VARCHAR) CREATE TABLE winners_of_the_orchid_handicap_since_1999 (winners_of_the_orchid_handicap_since_1999_id AUTO_INCREMENT PRIMARY KEY, Year INT, Winner VARCHAR, Jockey VARCHAR, Trainer VARCHAR, Owner VARCHAR, Time VARCHAR) CREATE TABLE cooperative_programs (cooperative_programs_id AUTO_INCREMENT PRIMARY KEY, Team Name VARCHAR, Schools VARCHAR, Sports VARCHAR, Host VARCHAR, Nickname(s) VARCHAR, Colors VARCHAR, Enrollment (2013/14) INT) CREATE TABLE performance_by_club (performance_by_club_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, # appearances INT, years (won in bold) VARCHAR, # wins INT, # runner-up INT, Most recent final VARCHAR) CREATE TABLE  (_id AUTO_INCREMENT PRIMARY KEY, District VARCHAR, Incumbent VARCHAR, Party VARCHAR, First elected INT, Result VARCHAR, Candidates VARCHAR)  
SELECT Candidates FROM  WHERE First elected = 1942