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: Qual candidato socialista concorreu contra a candidata do Trabalhismo Americano, Caroline O'Day?
 ###Tabelas: CREATE TABLE 1996_draft_picks (1996_draft_picks_id AUTO_INCREMENT PRIMARY KEY, Round INT, Overall INT, Player VARCHAR, Nationality VARCHAR, Club team VARCHAR) CREATE TABLE list_of_lighthouses_in_the_philippines (list_of_lighthouses_in_the_philippines_id AUTO_INCREMENT PRIMARY KEY, Lighthouse VARCHAR, Location VARCHAR, Province/City VARCHAR, Date First Lit VARCHAR, Tower height in ft (m) VARCHAR, Focal plane in ft (m) VARCHAR, Current Status VARCHAR, Current Condition/ Description VARCHAR) CREATE TABLE result (result_id AUTO_INCREMENT PRIMARY KEY, Office VARCHAR, Democratic ticket VARCHAR, Republican ticket VARCHAR, American Labor ticket VARCHAR, Socialist ticket VARCHAR) CREATE TABLE scratchers (scratchers_id AUTO_INCREMENT PRIMARY KEY, Game Name VARCHAR, Price VARCHAR, Top Prize VARCHAR, Launch Date VARCHAR, Odds of Winning VARCHAR) CREATE TABLE train_services (train_services_id AUTO_INCREMENT PRIMARY KEY, Train No. VARCHAR, Train Name VARCHAR, Origin VARCHAR, Destination VARCHAR, Frequency VARCHAR)  
SELECT Socialist ticket FROM result WHERE American Labor ticket = caroline o'day