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 eram os candidatos no distrito 4 da Louisiana?
 ###Tabelas: CREATE TABLE middle_schools (middle_schools_id AUTO_INCREMENT PRIMARY KEY, Information VARCHAR, Akimel A-al The name is Tohono Oodham for children of the river VARCHAR, Altadeña VARCHAR, Aprende VARCHAR, Centennial VARCHAR, Kyrene MS VARCHAR, del Pueblo VARCHAR) CREATE TABLE doubles_11_3–8 (doubles_11_3–8_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents in the final VARCHAR, Score VARCHAR) CREATE TABLE composition_of_the_6th_seanad (composition_of_the_6th_seanad_id AUTO_INCREMENT PRIMARY KEY, Administrative Panel INT, Agricultural Panel INT, Cultural and Educational Panel INT, Industrial and Commercial Panel INT, Labour Panel INT, National University of Ireland INT, University of Dublin INT, Nominated by the Taoiseach INT, Total INT) CREATE TABLE  (_id AUTO_INCREMENT PRIMARY KEY, District VARCHAR, Incumbent VARCHAR, Party VARCHAR, First elected INT, Result VARCHAR, Candidates VARCHAR) CREATE TABLE current_rolling_stock (current_rolling_stock_id AUTO_INCREMENT PRIMARY KEY, Class VARCHAR, Introduced VARCHAR, Number in class INT, Number in service INT, Power output (kW) INT)  
SELECT Candidates FROM  WHERE District = Louisiana 4