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: Que tipo de navios foram entregues em outubro de 1942?
 ###Tabelas: CREATE TABLE largest_attendance (largest_attendance_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Date VARCHAR, Attendance INT, Opponent VARCHAR, Texas Result VARCHAR) CREATE TABLE championship_teams_and_drivers (championship_teams_and_drivers_id AUTO_INCREMENT PRIMARY KEY, Constructor VARCHAR, Chassis VARCHAR, Engine VARCHAR, Tyre VARCHAR, Driver VARCHAR, Rounds VARCHAR) CREATE TABLE nasl_indoor_soccer (nasl_indoor_soccer_id AUTO_INCREMENT PRIMARY KEY, Indoor Year VARCHAR, Record VARCHAR, Regular Season Finish VARCHAR, Playoffs VARCHAR, Avg Attend. INT) CREATE TABLE shipyards_in_the_program (shipyards_in_the_program_id AUTO_INCREMENT PRIMARY KEY, Yard Name VARCHAR, Location (city, state) VARCHAR, 1st Ship Delivery Date VARCHAR, Ship Types Delivered VARCHAR, Total Number of Ways VARCHAR, total vessels built VARCHAR) CREATE TABLE qualifying_round (qualifying_round_id AUTO_INCREMENT PRIMARY KEY, Team #1 VARCHAR, Agg. VARCHAR, Team #2 VARCHAR, 1st leg VARCHAR, 2nd leg VARCHAR)  
SELECT Ship Types Delivered FROM shipyards_in_the_program WHERE 1st Ship Delivery Date = October 1942