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 era o candidato constitucional quando William Karlin era o candidato socialista?
 ###Tabelas: CREATE TABLE under_u.s._jurisdiction_territorial (under_u.s._jurisdiction_territorial_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Date of Execution VARCHAR, Crime VARCHAR, Method VARCHAR, Race VARCHAR) CREATE TABLE season-by-season_national_league_records (season-by-season_national_league_records_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Division VARCHAR, Position VARCHAR, Played VARCHAR, Lost VARCHAR, Points VARCHAR) CREATE TABLE models_and_engines (models_and_engines_id AUTO_INCREMENT PRIMARY KEY, model VARCHAR, max. motive power VARCHAR, max. torque at rpm VARCHAR, engine displacement VARCHAR, engine type VARCHAR, engine configuration & notes 0-100km/h VARCHAR) CREATE TABLE result (result_id AUTO_INCREMENT PRIMARY KEY, Office VARCHAR, Democratic ticket VARCHAR, Republican ticket VARCHAR, Socialist ticket VARCHAR, Constitutional ticket VARCHAR, Law Preservation ticket VARCHAR) CREATE TABLE upcoming_films (upcoming_films_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Type VARCHAR, Planned Release VARCHAR, CC License VARCHAR, Sources available VARCHAR, Open Source Movie VARCHAR)  
SELECT Constitutional ticket FROM result WHERE Socialist ticket = william karlin