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 bilhete do Partido Trabalhista Socialista possui um Escritório de secretário de estado?
 ###Tabelas: CREATE TABLE most-viewed_channels (most-viewed_channels_id AUTO_INCREMENT PRIMARY KEY, Position INT, Channel VARCHAR, Owner VARCHAR, Share (%) INT, Rating (%) INT) CREATE TABLE result (result_id AUTO_INCREMENT PRIMARY KEY, Office VARCHAR, Republican ticket VARCHAR, Democratic ticket VARCHAR, Socialist Labor ticket VARCHAR, Prohibition ticket VARCHAR, Independent Citizens' ticket VARCHAR) CREATE TABLE winning_head_of_the_river_championship_events (winning_head_of_the_river_championship_events_id AUTO_INCREMENT PRIMARY KEY, Crew INT, Open 1st VIII VARCHAR, Open 2nd VIII VARCHAR, Open 3rd VIII VARCHAR, U16 1st VIII VARCHAR, U16 2nd VIII VARCHAR, U16 3rd VIII VARCHAR, U15 1st IV VARCHAR, U15 2nd IV VARCHAR, U15 3rd IV VARCHAR, U15 4th IV VARCHAR, U15 5th IV VARCHAR, U15 6th IV VARCHAR) CREATE TABLE dos_shells (dos_shells_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Release date VARCHAR, Latest version VARCHAR, Status support VARCHAR, Source model VARCHAR, Architecture VARCHAR, Target market VARCHAR) CREATE TABLE sport (sport_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, League VARCHAR, Sport VARCHAR, Venue VARCHAR, Established INT, Capacity INT)  
SELECT Socialist Labor ticket FROM result WHERE Office = secretary of state